DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_MMT_GT

Line 1484: INSERT INTO CST_LC_MMT_GT

1480: l_stmt_num := 70;
1481:
1482: /* Insert Average cost update transactions for the deliveries of
1483: asset items into asset organizations */
1484: INSERT INTO CST_LC_MMT_GT
1485: (lcm_transaction_id,
1486: transaction_id,
1487: transaction_type_id,
1488: transaction_action_id,

Line 1599: UPDATE CST_LC_MMT_GT

1595:
1596: END IF;
1597:
1598: l_stmt_num := 75;
1599: UPDATE CST_LC_MMT_GT
1600: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1601:
1602: IF (l_sLog AND l_pLog) THEN
1603: l_num_records := SQL%ROWCOUNT;

Line 1620: INSERT INTO CST_LC_MMT_GT

1616:
1617: l_stmt_num := 90;
1618: /* Insert Layer cost update transactions for the deliveries of
1619: asset items into asset organizations */
1620: INSERT INTO CST_LC_MMT_GT
1621: (lcm_transaction_id,
1622: transaction_id,
1623: transaction_type_id,
1624: transaction_action_id,

Line 1750: UPDATE CST_LC_MMT_GT

1746:
1747: END IF;
1748:
1749: l_stmt_num := 100;
1750: UPDATE CST_LC_MMT_GT
1751: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1752:
1753: IF (l_sLog AND l_pLog) THEN
1754: l_num_records := SQL%ROWCOUNT;

Line 2238: FROM cst_lc_mmt_gt mmt,

2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE
2238: FROM cst_lc_mmt_gt mmt,
2239: cst_lc_adj_acctg_info_gt acc
2240: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2241:
2242: IF (l_sLog AND l_pLog) THEN

Line 2331: FROM CST_LC_MMT_GT;

2327: pm_cost_collected,
2328: owning_organization_id,
2329: owning_tp_type,
2330: transaction_uom
2331: FROM CST_LC_MMT_GT;
2332:
2333: IF (l_sLog AND l_pLog) THEN
2334: l_num_records := SQL%ROWCOUNT;
2335: FND_LOG.STRING(