APPS.CSTPMRGL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 522: mtl_material_transactions mmt, -- dropship

518: oe_order_lines_all sl_parent,
519: oe_order_lines_all sl_child,
520: mtl_system_items msi,
521: ra_customer_trx_all rct,
522: mtl_material_transactions mmt, -- dropship
523: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
524: WHERE
525: cr.build_id = l_build_id
526: AND rct.org_id = l_ou_id

Line 1059: mtl_material_transactions mmt,

1055: SUM(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 1237: mtl_material_transactions mmt,

1233: 0,
1234: crcml.COGS_ACCT_ID
1235: FROM cst_margin_build cr,
1236: cst_acct_info_v ood,
1237: mtl_material_transactions mmt,
1238: oe_order_lines_all sl_child,
1239: oe_order_lines_all sl_parent,
1240: oe_order_headers_all sh,
1241: mtl_parameters mp, /* INVCONV umoogala 17-oct-2004 */

Line 1380: FROM mtl_material_transactions

1376: and aid.line_type_lookup_code IN ('ITEM','ACCRUAL') --Invoice Lines Project
1377: AND LTRIM(AID.REFERENCE_1,'0123456789') IS NULL -- dropship <
1378: and NOT EXISTS
1379: (SELECT 'X'
1380: FROM mtl_material_transactions
1381: WHERE transaction_id = rcl.interface_line_attribute7
1382: AND transaction_source_type_id = 13) -- > dropship
1383: /* INVCONV umoogala 17-oct-2004 */
1384: and mp.organization_id(+) = sl_parent.ship_to_org_id

Line 1477: mtl_material_transactions mmt,

1473: FROM
1474: cst_margin_build cr,
1475: oe_order_headers_all rma,
1476: oe_order_lines_all rma_line,
1477: mtl_material_transactions mmt,
1478: cst_organization_definitions cod,
1479: mtl_transaction_accounts mta,
1480: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1481: WHERE cr.build_id = l_build_id