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.CSTPOMLD dependencies on OE_ORDER_LINES_ALL

Line 363: oe_order_lines_all sl_parent,

359: CST_BIS_MARGIN_BUILD cr,
360: ra_cust_trx_line_gl_dist_all rctlgd,
361: ra_customer_trx_lines_all rctl,
362: oe_order_headers_all sh,
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

Line 364: oe_order_lines_all sl_child,

360: ra_cust_trx_line_gl_dist_all rctlgd,
361: ra_customer_trx_lines_all rctl,
362: oe_order_headers_all sh,
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

Line 506: oe_order_lines_all sl_parent,

502: CST_BIS_MARGIN_BUILD cr,
503: ra_cust_trx_line_gl_dist_all rctlgd,
504: ra_customer_trx_lines_all rctl,
505: oe_order_headers_all sh,
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

Line 507: oe_order_lines_all sl_child,

503: ra_cust_trx_line_gl_dist_all rctlgd,
504: ra_customer_trx_lines_all rctl,
505: oe_order_headers_all sh,
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

Line 649: oe_order_lines_all rma_line,

645: CST_BIS_MARGIN_BUILD cr,
646: ra_cust_trx_line_gl_dist_all rctlgd,
647: ra_customer_trx_lines_all rctl,
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

Line 781: oe_order_lines_all rma_line,

777: CST_BIS_MARGIN_BUILD cr,
778: ra_cust_trx_line_gl_dist_all rctlgd,
779: ra_customer_trx_lines_all rctl,
780: oe_order_headers_all rma,
781: oe_order_lines_all rma_line,
782: mtl_system_items msi,
783: -- new changes for intercompany invoicing
784: org_organization_definitions ood,
785: ra_customer_trx_all rct

Line 878: oe_order_lines_all sl_parent,

874: rma.invoice_quantity, 0),
875: sl_child.return_context,
876: sl_child.reference_line_id
877: FROM
878: oe_order_lines_all sl_parent,
879: oe_order_lines_all sl_child,
880: oe_order_headers_all sh
881: WHERE
882: sl_parent.org_id = l_ou_id

Line 879: oe_order_lines_all sl_child,

875: sl_child.return_context,
876: sl_child.reference_line_id
877: FROM
878: oe_order_lines_all sl_parent,
879: oe_order_lines_all sl_child,
880: oe_order_headers_all sh
881: WHERE
882: sl_parent.org_id = l_ou_id
883: and sl_child.org_id = l_ou_id

Line 1009: oe_order_lines_all rma_line,

1005: CST_BIS_MARGIN_BUILD cr,
1006: ra_cust_trx_line_gl_dist_all rctlgd,
1007: ra_customer_trx_lines_all rctl,
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

Line 1175: oe_order_lines_all oel

1171: t1.CUSTOMER_TRX_LINE_ID )
1172: and not exists
1173: (select 'x'
1174: from CST_BIS_MARGIN_SUMMARY t2,
1175: oe_order_lines_all oel
1176: where t2.source = 'RMA-INVOICE'
1177: and t2.build_id = temp.build_id
1178: /* added join to org_id bug 2554225 */
1179: and t2.org_id = l_ou_id

Line 1307: oe_order_lines_all sl_parent,

1303: mta.base_transaction_value,
1304: mta.reference_account
1305: FROM
1306: oe_order_headers_all sh,
1307: oe_order_lines_all sl_parent,
1308: oe_order_lines_all sl_child,
1309: mtl_material_transactions mmt,
1310: mtl_transaction_accounts mta,
1311: -- new changes for intercompany invoicing

Line 1308: oe_order_lines_all sl_child,

1304: mta.reference_account
1305: FROM
1306: oe_order_headers_all sh,
1307: oe_order_lines_all sl_parent,
1308: oe_order_lines_all sl_child,
1309: mtl_material_transactions mmt,
1310: mtl_transaction_accounts mta,
1311: -- new changes for intercompany invoicing
1312: org_organization_definitions ood,

Line 1440: oe_order_lines_all sl_parent,

1436: CST_BIS_MARGIN_BUILD cr,
1437: ap_invoice_distributions_all aid,
1438: ap_invoices_all ai,
1439: oe_order_headers_all sh,
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

Line 1441: oe_order_lines_all sl_child,

1437: ap_invoice_distributions_all aid,
1438: ap_invoices_all ai,
1439: oe_order_headers_all sh,
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

Line 1575: oe_order_lines_all rma_line,

1571: mta.base_transaction_value
1572: FROM
1573: CST_BIS_MARGIN_BUILD cr,
1574: oe_order_headers_all rma,
1575: oe_order_lines_all rma_line,
1576: mtl_material_transactions mmt,
1577: -- new changes for intercompany invoicing
1578: org_organization_definitions ood,
1579: mtl_transaction_accounts mta,

Line 1680: oe_order_lines_all sl_parent,

1676: ),
1677: sl_child.return_context,
1678: sl_child.reference_line_id
1679: FROM
1680: oe_order_lines_all sl_parent,
1681: oe_order_lines_all sl_child,
1682: oe_order_headers_all sh
1683: WHERE
1684: NVL(sl_parent.org_id, -999) =

Line 1681: oe_order_lines_all sl_child,

1677: sl_child.return_context,
1678: sl_child.reference_line_id
1679: FROM
1680: oe_order_lines_all sl_parent,
1681: oe_order_lines_all sl_child,
1682: oe_order_headers_all sh
1683: WHERE
1684: NVL(sl_parent.org_id, -999) =
1685: NVL(l_ou_id, NVL(sl_parent.org_id, -999))