APPS.CSTPMRGL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 516: mtl_material_transactions mmt, -- dropship

512: oe_order_lines_all sl_parent,
513: oe_order_lines_all sl_child,
514: mtl_system_items msi,
515: ra_customer_trx_all rct,
516: mtl_material_transactions mmt, -- dropship
517: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
518: WHERE
519: cr.build_id = l_build_id
520: AND rct.org_id = l_ou_id

Line 1059: mtl_material_transactions mmt,

1055: mta.base_transaction_value,
1056: mta.reference_account
1057: FROM cst_margin_build cr,
1058: cst_acct_info_v ood,
1059: mtl_material_transactions mmt,
1060: mtl_transaction_accounts mta,
1061: oe_order_lines_all sl_child,
1062: oe_order_lines_all sl_parent,
1063: oe_order_headers_all sh,

Line 1195: FROM mtl_material_transactions

1191: and aid.line_type_lookup_code IN ('ITEM','ACCRUAL') --Invoice Lines Project
1192: AND LTRIM(AID.REFERENCE_1,'0123456789') IS NULL -- dropship <
1193: and NOT EXISTS
1194: (SELECT 'X'
1195: FROM mtl_material_transactions
1196: WHERE transaction_id = rcl.interface_line_attribute7
1197: AND transaction_source_type_id = 13) -- > dropship
1198: /* INVCONV umoogala 17-oct-2004 */
1199: and mp.organization_id = sl_parent.ship_to_org_id

Line 1292: mtl_material_transactions mmt,

1288: FROM
1289: cst_margin_build cr,
1290: oe_order_headers_all rma,
1291: oe_order_lines_all rma_line,
1292: mtl_material_transactions mmt,
1293: cst_organization_definitions cod,
1294: mtl_transaction_accounts mta,
1295: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1296: WHERE cr.build_id = l_build_id