eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 523: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

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

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

676: ra_customer_trx_all rct,
677: oe_order_headers_all rma,
678: oe_order_lines_all rma_line,
679: mtl_system_items msi,
680: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
681: WHERE cr.build_id = l_build_id
682: AND rctl.org_id = l_ou_id
683: AND rctl.line_type = 'LINE'
684: 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 1241: mtl_parameters mp, /* INVCONV umoogala 17-oct-2004 */

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 */
1242: cst_revenue_cogs_match_lines crcml
1243: WHERE cr.build_id = l_build_id
1244: AND (mmt.transaction_source_type_id in (2,8) -- dropship
1245: OR mmt.transaction_action_id = 9)

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

1358: oe_order_headers_all sh,
1359: oe_order_lines_all sl_parent,
1360: oe_order_lines_all sl_child,
1361: ra_customer_trx_lines_all rcl,
1362: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1363: WHERE
1364: ai.invoice_id = aid.invoice_id
1365: and ai.source = 'Intercompany'
1366: and ai.org_id = aid.org_id

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

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