DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_MMT_GT

Line 1468: INSERT INTO CST_LC_MMT_GT

1464: l_stmt_num := 70;
1465:
1466: /* Insert Average cost update transactions for the deliveries of
1467: asset items into asset organizations */
1468: INSERT INTO CST_LC_MMT_GT
1469: (lcm_transaction_id,
1470: transaction_id,
1471: transaction_type_id,
1472: transaction_action_id,

Line 1582: UPDATE CST_LC_MMT_GT

1578:
1579: END IF;
1580:
1581: l_stmt_num := 75;
1582: UPDATE CST_LC_MMT_GT
1583: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1584:
1585: IF (l_sLog AND l_pLog) THEN
1586: l_num_records := SQL%ROWCOUNT;

Line 1603: INSERT INTO CST_LC_MMT_GT

1599:
1600: l_stmt_num := 90;
1601: /* Insert Layer cost update transactions for the deliveries of
1602: asset items into asset organizations */
1603: INSERT INTO CST_LC_MMT_GT
1604: (lcm_transaction_id,
1605: transaction_id,
1606: transaction_type_id,
1607: transaction_action_id,

Line 1732: UPDATE CST_LC_MMT_GT

1728:
1729: END IF;
1730:
1731: l_stmt_num := 100;
1732: UPDATE CST_LC_MMT_GT
1733: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1734:
1735: IF (l_sLog AND l_pLog) THEN
1736: l_num_records := SQL%ROWCOUNT;

Line 2220: FROM cst_lc_mmt_gt mmt,

2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE
2220: FROM cst_lc_mmt_gt mmt,
2221: cst_lc_adj_acctg_info_gt acc
2222: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2223:
2224: IF (l_sLog AND l_pLog) THEN

Line 2313: FROM CST_LC_MMT_GT;

2309: pm_cost_collected,
2310: owning_organization_id,
2311: owning_tp_type,
2312: transaction_uom
2313: FROM CST_LC_MMT_GT;
2314:
2315: IF (l_sLog AND l_pLog) THEN
2316: l_num_records := SQL%ROWCOUNT;
2317: FND_LOG.STRING(