APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on CST_PERIOD_CLOSE_SUMMARY

Line 1668: FROM cst_period_close_summary

1664: AND acct_period_id = p_period_id
1665: AND summarized_flag = 'N'
1666: AND EXISTS
1667: (SELECT 'Data exists in CPCS'
1668: FROM cst_period_close_summary
1669: WHERE organization_id = p_org_id
1670: AND acct_period_id = p_period_id);
1671:
1672: IF (l_resummarize > 0) THEN

Line 1686: DELETE cst_period_close_summary

1682: END IF;
1683:
1684: l_stmt_num := 35;
1685:
1686: DELETE cst_period_close_summary
1687: WHERE organization_id = p_org_id
1688: AND acct_period_id >= p_period_id;
1689:
1690: /* Updating org_acct_periods in case the customer has not updated summarized_flag

Line 1712: FROM cst_period_close_summary

1708:
1709: --check if CPCS is empty
1710: SELECT count(*)
1711: INTO l_cpcs_count
1712: FROM cst_period_close_summary
1713: WHERE organization_id = p_org_id
1714: AND rownum = 1;
1715:
1716: l_stmt_num := 45;

Line 1943: cst_period_close_summary CPCS

1939: CPCS.subinventory_code,
1940: CPCS.inventory_item_id,
1941: CPCS.rollback_onhand_value
1942: FROM
1943: cst_period_close_summary CPCS
1944: WHERE CPCS.organization_id = p_org_id
1945: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1946:
1947: UNION ALL

Line 1957: cst_period_close_summary CPCS

1953: CPCS.subinventory_code,
1954: CPCS.inventory_item_id,
1955: CPCS.rollback_intransit_value
1956: FROM
1957: cst_period_close_summary CPCS
1958: WHERE CPCS.organization_id = p_org_id
1959: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1960:
1961: UNION ALL

Line 1971: cst_period_close_summary CPCS

1967: CPCS.subinventory_code,
1968: CPCS.inventory_item_id,
1969: CPCS.cumulative_onhand_mta
1970: FROM
1971: cst_period_close_summary CPCS
1972: WHERE CPCS.organization_id = p_org_id
1973: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
1974:
1975: UNION ALL

Line 1985: cst_period_close_summary CPCS

1981: CPCS.subinventory_code,
1982: CPCS.inventory_item_id,
1983: CPCS.cumulative_intransit_mta
1984: FROM
1985: cst_period_close_summary CPCS
1986: WHERE CPCS.organization_id = p_org_id
1987: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1); */
1988:
1989: /* Bug 14036099 */

Line 2052: cst_period_close_summary CPCS

2048: CPCS.rollback_intransit_value,
2049: CPCS.cumulative_onhand_mta,
2050: CPCS.cumulative_intransit_mta
2051: FROM
2052: cst_period_close_summary CPCS
2053: WHERE CPCS.organization_id = p_org_id
2054: AND CPCS.acct_period_id = NVL(l_prior_period_id,-1)
2055: AND (rollback_quantity <> 0 OR
2056: rollback_onhand_value <> 0 OR

Line 2369: INTO cst_period_close_summary(

2365: l_stmt_num := 120;
2366: x_return_status := '2';
2367: --period closed -> CPCS
2368: INSERT
2369: INTO cst_period_close_summary(
2370: acct_period_id,
2371: organization_id,
2372: cost_group_id,
2373: subinventory_code,