APPS.CSTPMRGL dependencies on MTL_PARAMETERS

Line 375: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

371: oe_order_lines_all sl_child,
372: oe_order_lines_all sl_parent,
373: mtl_system_items msi,
374: oe_order_headers_all sh,
375: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
376: WHERE
377: cr.build_id = l_build_id
378: AND rct.org_id = l_ou_id
379: AND rctlgd.org_id = l_ou_id

Line 517: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

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
521: AND rctlgd.org_id = l_ou_id

Line 666: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

662: ra_customer_trx_all rct,
663: oe_order_headers_all rma,
664: oe_order_lines_all rma_line,
665: mtl_system_items msi,
666: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
667: WHERE cr.build_id = l_build_id
668: AND rctl.org_id = l_ou_id
669: AND rctl.line_type = 'LINE'
670: AND rctl.customer_trx_id = rct.customer_trx_id

Line 1064: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

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,
1064: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1065: WHERE cr.build_id = l_build_id
1066: AND (mmt.transaction_source_type_id in (2,8) -- dropship
1067: OR mmt.transaction_action_id = 9)
1068: AND transaction_action_id <> 28

Line 1177: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

1173: oe_order_headers_all sh,
1174: oe_order_lines_all sl_parent,
1175: oe_order_lines_all sl_child,
1176: ra_customer_trx_lines_all rcl,
1177: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1178: WHERE
1179: ai.invoice_id = aid.invoice_id
1180: and ai.source = 'Intercompany'
1181: and ai.org_id = aid.org_id

Line 1295: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

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
1297: AND (mmt.transaction_source_type_id = 12 -- dropship <
1298: OR mmt.transaction_action_id = 14) -- logical I/C sales return
1299: AND mta.transaction_source_type_id = mmt.transaction_source_type_id -- > dropship