APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_ACCOUNTS_GT

Line 427: FROM cst_lc_accounts_gt t;

423: and group_id = p_group_id;
424:
425: CURSOR c_adj_offset_account IS
426: SELECT t.*, t.rowid
427: FROM cst_lc_accounts_gt t;
428:
429: BEGIN
430:
431: l_stmt_num := 0;

Line 736: INSERT INTO CST_LC_ACCOUNTS_GT

732: 6. | Y | N | Expense | 2 || SUBINVENTORY EXPENSE ACCOUNT |
733: 7. | N | Y | Landed Cost Absorption | 38 || ORG LANDED COST ABSORPTION ACCOUNT|
734: 8. | N | N | Expense | 2 || CG EXPENSE ACCOUNT |
735: --------------------------------------------------------------------------------------------------*/
736: INSERT INTO CST_LC_ACCOUNTS_GT
737: (LCM_TRANSACTION_ID,
738: RCV_TRANSACTION_ID,
739: TRANSACTION_ID,
740: COST_GROUP_ID,

Line 935: UPDATE cst_lc_accounts_gt

931: l_stmt_num := 120;
932: IF l_acct_id <> -1 THEN
933:
934: l_stmt_num := 130;
935: UPDATE cst_lc_accounts_gt
936: SET account = l_acct_id
937: WHERE rowid = c_account.rowid;
938:
939: END IF;

Line 967: DELETE FROM cst_lc_accounts_gt t

963:
964: END IF;
965:
966: l_stmt_num := 150;
967: DELETE FROM cst_lc_accounts_gt t
968: WHERE EXISTS (SELECT 1
969: FROM cst_lc_adj_interface_errors e
970: WHERE e.transaction_id = t.lcm_transaction_id
971: AND e.group_id = p_group_id

Line 1428: cst_lc_accounts_gt adj_acc

1424: fnd_global.conc_request_id,
1425: 'N'
1426: FROM cst_lc_adj_acctg_info_gt acc,
1427: cst_lc_rcv_txn_gt rt,
1428: cst_lc_accounts_gt adj_acc
1429: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1430: or (rt.transaction_type = 'CORRECT'
1431: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))
1432: and rt.lcm_transaction_id = acc.lcm_transaction_id