DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_ADJ_TRANSACTIONS

Line 2387: INSERT INTO cst_lc_adj_transactions

2383: p_source_application_id => 201);
2384:
2385: l_stmt_num := 80;
2386: /* Insert into the LCM transactions table to maintain history of this adjustment */
2387: INSERT INTO cst_lc_adj_transactions
2388: (transaction_id,
2389: rcv_transaction_id,
2390: organization_id,
2391: inventory_item_id,

Line 2445: FROM cst_lc_adj_transactions t

2441: WHERE e.group_id = p_group_id
2442: AND e.organization_id = p_organization_id
2443: AND e.process_status = 2
2444: AND EXISTS (SELECT 1
2445: FROM cst_lc_adj_transactions t
2446: WHERE t.transaction_id = e.transaction_id);
2447:
2448: IF (l_sLog AND l_pLog) THEN
2449: l_num_records := SQL%ROWCOUNT;