DBA Data[Home] [Help]

APPS.CSTPOMLD dependencies on MTL_PARAMETERS

Line 367: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

363: oe_order_lines_all sl_parent,
364: oe_order_lines_all sl_child,
365: mtl_system_items msi,
366: ra_customer_trx_all rct,
367: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
368: WHERE
369: cr.build_id = l_build_id
370: and rctl.org_id = l_ou_id
371: and rct.org_id = l_ou_id

Line 510: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

506: oe_order_lines_all sl_parent,
507: oe_order_lines_all sl_child,
508: mtl_system_items msi,
509: ra_customer_trx_all rct,
510: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
511: WHERE
512: cr.build_id = l_build_id
513: and rctl.org_id = l_ou_id
514: and rct.org_id = l_ou_id

Line 652: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

648: oe_order_headers_all rma,
649: oe_order_lines_all rma_line,
650: --hr_organization_information hoi,
651: ra_customer_trx_all rct,
652: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
653: WHERE
654: cr.build_id = l_build_id
655: and rctl.org_id = l_ou_id
656: and rct.org_id = l_ou_id

Line 1012: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

1008: oe_order_headers_all rma,
1009: oe_order_lines_all rma_line,
1010: --hr_organization_information hoi,
1011: ra_customer_trx_all rct,
1012: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1013: WHERE
1014: cr.build_id = l_build_id
1015: and rctl.org_id = l_ou_id
1016: and rct.org_id = l_ou_id

Line 1314: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

1310: mtl_transaction_accounts mta,
1311: -- new changes for intercompany invoicing
1312: org_organization_definitions ood,
1313: CST_BIS_MARGIN_BUILD cr,
1314: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1315: WHERE
1316: cr.build_id = l_build_id
1317: and (
1318: (mmt.transaction_source_type_id = 2 -- Regular Sales Orders

Line 1444: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

1440: oe_order_lines_all sl_parent,
1441: oe_order_lines_all sl_child,
1442: ra_customer_trx_lines_all rcl,
1443: mtl_material_transactions mmt ,
1444: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1445: WHERE
1446: ai.invoice_id = aid.invoice_id
1447: and ai.source = 'Intercompany'
1448: and ai.org_id = aid.org_id

Line 1580: mtl_parameters mp -- INVCONV umoogala 17-oct-2004

1576: mtl_material_transactions mmt,
1577: -- new changes for intercompany invoicing
1578: org_organization_definitions ood,
1579: mtl_transaction_accounts mta,
1580: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1581: WHERE
1582: cr.build_id = l_build_id
1583: and (
1584: (mmt.transaction_source_type_id = 12 -- RMA

Line 2045: , mtl_parameters MP

2041: (select max(MC.category_id)
2042: from
2043: mtl_categories MC
2044: , mtl_category_sets MCS
2045: , mtl_parameters MP
2046: , mtl_item_categories MIC
2047: , mtl_default_category_sets MDCS
2048: where
2049: temp.parent_organization_id = MP.organization_id