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 3090: mtl_material_transactions mmt

3086: stmt_num := 410;
3087: SELECT count(*)
3088: INTO l_count
3089: FROM mtl_cst_txn_cost_details mctcd,
3090: mtl_material_transactions mmt
3091: WHERE mctcd.transaction_id = mmt.transaction_id
3092: AND mctcd.transaction_id = i_trx_id
3093: AND mctcd.transaction_cost < 0;
3094:

Line 3325: mtl_material_transactions mmt,

3321: NULL,
3322: i_request_id, i_prog_appl_id,
3323: i_prog_id, sysdate
3324: FROM mtl_cst_txn_cost_details mctcd,
3325: mtl_material_transactions mmt,
3326: wip_discrete_jobs wdj,
3327: fnd_currencies c1
3328: WHERE mctcd.transaction_id = mmt.transaction_id
3329: AND mmt.transaction_source_id = wdj.wip_entity_id

Line 3389: mtl_material_transactions mmt,

3385: NULL,
3386: i_request_id, i_prog_appl_id,
3387: i_prog_id, sysdate
3388: FROM mtl_cst_txn_cost_details mctcd,
3389: mtl_material_transactions mmt,
3390: wip_discrete_jobs wdj,
3391: fnd_currencies c1
3392: WHERE mctcd.transaction_id = mmt.transaction_id
3393: AND mmt.transaction_source_id = wdj.wip_entity_id

Line 3445: mtl_material_transactions mmt,

3441: NULL,
3442: i_request_id, i_prog_appl_id,
3443: i_prog_id, sysdate
3444: FROM mtl_cst_txn_cost_details mctcd,
3445: mtl_material_transactions mmt,
3446: wip_discrete_jobs wdj,
3447: fnd_currencies c1
3448: WHERE mctcd.transaction_id = mmt.transaction_id
3449: AND mmt.transaction_source_id = wdj.wip_entity_id