DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_RAE_EVENTS_GT

Line 1161: INSERT INTO CST_LC_RAE_EVENTS_GT

1157:
1158: l_stmt_num := 10;
1159:
1160: /* Create the Receipt Adjustment Events - Event type id = 15 */
1161: INSERT INTO CST_LC_RAE_EVENTS_GT
1162: (LCM_TRANSACTION_ID,
1163: ACCOUNTING_EVENT_ID,
1164: EVENT_SOURCE,
1165: EVENT_SOURCE_ID,

Line 1311: INSERT INTO CST_LC_RAE_EVENTS_GT

1307: l_stmt_num := 20;
1308:
1309: /* Create the Delivery Adjustment Events - Event type id = 16,17 */
1310: l_stmt_num := 30;
1311: INSERT INTO CST_LC_RAE_EVENTS_GT
1312: (LCM_TRANSACTION_ID,
1313: ACCOUNTING_EVENT_ID,
1314: EVENT_SOURCE,
1315: EVENT_SOURCE_ID,

Line 1459: UPDATE CST_LC_RAE_EVENTS_GT

1455:
1456: END IF;
1457:
1458: l_stmt_num := 50;
1459: UPDATE CST_LC_RAE_EVENTS_GT
1460: SET accounting_event_id = rcv_accounting_event_s.NEXTVAL;
1461:
1462: l_stmt_num := 60;
1463: IF p_primary_cost_method = 2 THEN

Line 1968: FROM cst_lc_rae_events_gt;

1964: last_update_login,
1965: last_updated_by,
1966: request_id,
1967: accounted_flag
1968: FROM cst_lc_rae_events_gt;
1969:
1970: IF (l_sLog AND l_pLog) THEN
1971: l_num_records := SQL%ROWCOUNT;
1972: FND_LOG.STRING(

Line 2070: FROM cst_lc_rae_events_gt rae,

2066: 0,
2067: 0,
2068: 0,
2069: 0
2070: FROM cst_lc_rae_events_gt rae,
2071: cst_lc_adj_acctg_info_gt acc
2072: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2073:
2074: IF (l_sLog AND l_pLog) THEN

Line 2172: FROM cst_lc_rae_events_gt rae,

2168: 0,
2169: 0,
2170: 0,
2171: 0
2172: FROM cst_lc_rae_events_gt rae,
2173: cst_lc_adj_acctg_info_gt acc
2174: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2175:
2176: IF (l_sLog AND l_pLog) THEN

Line 2360: FROM cst_lc_rae_events_gt rae,

2356: rae.transaction_date,
2357: acc.accounting_date,
2358: rae.accounting_event_id,
2359: NULL
2360: FROM cst_lc_rae_events_gt rae,
2361: cst_lc_adj_acctg_info_gt acc,
2362: cst_xla_rcv_event_map cmap
2363: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id
2364: AND cmap.event_class_code IN ('LDD_COST_ADJ_RCV', 'LDD_COST_ADJ_DEL')