APPS.CSTPACWC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 347: FROM mtl_material_transactions

343: BEGIN
344: stmt_num := 100;
345: SELECT nvl(sum(primary_quantity),0)
346: INTO l_future_issued_qty
347: FROM mtl_material_transactions
348: WHERE organization_id = wro_rec.organization_id
349: AND inventory_item_id = wro_rec.inventory_item_id
350: AND operation_seq_num = wro_rec.operation_seq_num
351: AND transaction_source_id = wro_rec.wip_entity_id

Line 357: from mtl_material_transactions

353: (transaction_date = i_txn_date and transaction_id > i_trx_id) )
354: AND costed_flag IS NOT NULL
355: AND nvl(completion_transaction_id,-999) <>
356: ( Select nvl(completion_transaction_id,-999)
357: from mtl_material_transactions
358: where transaction_id = i_trx_id);
359: EXCEPTION
360: WHEN Others THEN
361: l_future_issued_qty := 0;

Line 898: FROM mtl_material_transactions

894: BEGIN
895: stmt_num := 160;
896: SELECT nvl(sum(primary_quantity),0)
897: INTO l_future_issued_qty
898: FROM mtl_material_transactions
899: WHERE organization_id = wro_rec.organization_id
900: AND inventory_item_id = wro_rec.inventory_item_id
901: AND operation_seq_num = wro_rec.operation_seq_num
902: AND transaction_source_id = wro_rec.wip_entity_id

Line 908: from mtl_material_transactions

904: (transaction_date = i_txn_date and transaction_id > i_trx_id) )
905: AND costed_flag IS NOT NULL
906: AND nvl(completion_transaction_id,-999) <>
907: ( Select nvl(completion_transaction_id,-999)
908: from mtl_material_transactions
909: where transaction_id = i_trx_id);
910: EXCEPTION
911: WHEN Others THEN
912: l_future_issued_qty := 0;

Line 1345: FROM mtl_material_transactions

1341:
1342: BEGIN
1343: SELECT nvl(sum(primary_quantity),0)
1344: INTO l_future_issued_qty
1345: FROM mtl_material_transactions
1346: WHERE organization_id = wro_rec.organization_id
1347: AND inventory_item_id = wro_rec.inventory_item_id
1348: AND operation_seq_num = wro_rec.operation_seq_num
1349: AND transaction_source_id = wro_rec.wip_entity_id

Line 1357: from mtl_material_transactions

1353: AND costed_flag IS NOT NULL
1354: /* Applied nvl for bug 2391936 */
1355: AND nvl(completion_transaction_id,-999) <>
1356: ( Select nvl(completion_transaction_id,-999)
1357: from mtl_material_transactions
1358: where transaction_id = i_trx_id);
1359: EXCEPTION
1360: WHEN Others THEN
1361: l_future_issued_qty := 0;

Line 2954: mtl_material_transactions mmt

2950: stmt_num := 410;
2951: SELECT count(*)
2952: INTO l_count
2953: FROM mtl_cst_txn_cost_details mctcd,
2954: mtl_material_transactions mmt
2955: WHERE mctcd.transaction_id = mmt.transaction_id
2956: AND mctcd.transaction_id = i_trx_id
2957: AND mctcd.transaction_cost < 0;
2958:

Line 3183: mtl_material_transactions mmt,

3179: NULL,
3180: i_request_id, i_prog_appl_id,
3181: i_prog_id, sysdate
3182: FROM mtl_cst_txn_cost_details mctcd,
3183: mtl_material_transactions mmt,
3184: wip_discrete_jobs wdj,
3185: fnd_currencies c1
3186: WHERE mctcd.transaction_id = mmt.transaction_id
3187: AND mmt.transaction_source_id = wdj.wip_entity_id

Line 3247: mtl_material_transactions mmt,

3243: NULL,
3244: i_request_id, i_prog_appl_id,
3245: i_prog_id, sysdate
3246: FROM mtl_cst_txn_cost_details mctcd,
3247: mtl_material_transactions mmt,
3248: wip_discrete_jobs wdj,
3249: fnd_currencies c1
3250: WHERE mctcd.transaction_id = mmt.transaction_id
3251: AND mmt.transaction_source_id = wdj.wip_entity_id

Line 3303: mtl_material_transactions mmt,

3299: NULL,
3300: i_request_id, i_prog_appl_id,
3301: i_prog_id, sysdate
3302: FROM mtl_cst_txn_cost_details mctcd,
3303: mtl_material_transactions mmt,
3304: wip_discrete_jobs wdj,
3305: fnd_currencies c1
3306: WHERE mctcd.transaction_id = mmt.transaction_id
3307: AND mmt.transaction_source_id = wdj.wip_entity_id