CST_PAC_RESET_GT

This session global temporary table is used to store the cost organization and PAC cost book combinations for the active request.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
COST_ORG_ID NUMBER 18 Identifies the cost organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Identifies the cost book assigned to the cost organization.
PERIOD_NAME VARCHAR2 15 Period for which cost processor is run. This value is populated for the transactions in periodic average cost method.
PERIOD_START_DATE DATE Identifies the start date of the costing period.
FULL_RESET_FLAG VARCHAR2 1 Indicates whether cost organization/cost book combination for the current period would require a full reset. Possible values are: NULL: Default value. Full reset is not required. Y: Full reset is required.