DBA Data[Home] [Help]

APPS.CSTPCFMS dependencies on MTL_CST_TXN_COST_DETAILS

Line 169: INSERT INTO mtl_cst_txn_cost_details

165: AND (i_txn_action_id = 31 OR (i_txn_action_id = 30 AND i_txn_qty>0))) THEN
166:
167: stmt_num := 10;
168: debug(stmt_num);
169: INSERT INTO mtl_cst_txn_cost_details
170: (
171: transaction_id,
172: organization_id,
173: inventory_item_id,

Line 232: INSERT INTO mtl_cst_txn_cost_details

228: 5,sum(nvl(tl_overhead_in,0) - nvl(tl_overhead_out,0))) > 0;
229:
230: stmt_num := 20;
231: debug(stmt_num);
232: INSERT INTO mtl_cst_txn_cost_details
233: (
234: transaction_id,
235: organization_id,
236: inventory_item_id,

Line 328: mtl_cst_txn_cost_details

324: i_prog_appl_id,
325: i_prog_id,
326: SYSDATE
327: FROM
328: mtl_cst_txn_cost_details
329: WHERE
330: transaction_id = i_trx_id;
331: END IF;
332: END IF;

Line 392: INSERT INTO mtl_cst_txn_cost_details

388: stmt_num := 10;
389:
390: debug(stmt_num);
391:
392: INSERT INTO mtl_cst_txn_cost_details
393: (
394: transaction_id,
395: organization_id,
396: inventory_item_id,

Line 455: INSERT INTO mtl_cst_txn_cost_details

451: 5,sum(nvl(tl_overhead_out,0) - nvl(tl_overhead_in,0))) > 0;
452:
453: stmt_num := 20;
454: debug(stmt_num);
455: INSERT INTO mtl_cst_txn_cost_details
456: (
457: transaction_id,
458: organization_id,
459: inventory_item_id,

Line 550: mtl_cst_txn_cost_details

546: i_prog_appl_id,
547: i_prog_id,
548: SYSDATE
549: FROM
550: mtl_cst_txn_cost_details
551: WHERE
552: transaction_id = i_trx_id;
553: END IF;
554: