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 1320: INSERT INTO CST_LC_RAE_EVENTS_GT

1316: l_stmt_num := 20;
1317:
1318: /* Create the Delivery Adjustment Events - Event type id = 16,17 */
1319: l_stmt_num := 30;
1320: INSERT INTO CST_LC_RAE_EVENTS_GT
1321: (LCM_TRANSACTION_ID,
1322: ACCOUNTING_EVENT_ID,
1323: EVENT_SOURCE,
1324: EVENT_SOURCE_ID,

Line 1475: UPDATE CST_LC_RAE_EVENTS_GT

1471:
1472: END IF;
1473:
1474: l_stmt_num := 50;
1475: UPDATE CST_LC_RAE_EVENTS_GT
1476: SET accounting_event_id = rcv_accounting_event_s.NEXTVAL;
1477:
1478: l_stmt_num := 60;
1479: IF p_primary_cost_method = 2 THEN

Line 1986: FROM cst_lc_rae_events_gt;

1982: last_update_login,
1983: last_updated_by,
1984: request_id,
1985: accounted_flag
1986: FROM cst_lc_rae_events_gt;
1987:
1988: IF (l_sLog AND l_pLog) THEN
1989: l_num_records := SQL%ROWCOUNT;
1990: FND_LOG.STRING(

Line 2088: FROM cst_lc_rae_events_gt rae,

2084: 0,
2085: 0,
2086: 0,
2087: 0
2088: FROM cst_lc_rae_events_gt rae,
2089: cst_lc_adj_acctg_info_gt acc
2090: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2091:
2092: IF (l_sLog AND l_pLog) THEN

Line 2190: FROM cst_lc_rae_events_gt rae,

2186: 0,
2187: 0,
2188: 0,
2189: 0
2190: FROM cst_lc_rae_events_gt rae,
2191: cst_lc_adj_acctg_info_gt acc
2192: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2193:
2194: IF (l_sLog AND l_pLog) THEN

Line 2378: FROM cst_lc_rae_events_gt rae,

2374: rae.transaction_date,
2375: acc.accounting_date,
2376: rae.accounting_event_id,
2377: NULL
2378: FROM cst_lc_rae_events_gt rae,
2379: cst_lc_adj_acctg_info_gt acc,
2380: cst_xla_rcv_event_map cmap
2381: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id
2382: AND cmap.event_class_code IN ('LDD_COST_ADJ_RCV', 'LDD_COST_ADJ_DEL')