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 OE_ORDER_LINES_ALL

Line 371: oe_order_lines_all sl_child,

367: cst_margin_build cr,
368: ra_cust_trx_line_gl_dist_all rctlgd,
369: ra_customer_trx_lines_all rctl,
370: ra_customer_trx_all rct,
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 */

Line 372: oe_order_lines_all sl_parent,

368: ra_cust_trx_line_gl_dist_all rctlgd,
369: ra_customer_trx_lines_all rctl,
370: ra_customer_trx_all rct,
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

Line 512: oe_order_lines_all sl_parent,

508: cst_margin_build cr,
509: ra_cust_trx_line_gl_dist_all rctlgd,
510: ra_customer_trx_lines_all rctl,
511: oe_order_headers_all sh,
512: oe_order_lines_all sl_parent,
513: oe_order_lines_all sl_child,
514: mtl_system_items msi,
515: ra_customer_trx_all rct,
516: mtl_material_transactions mmt, -- dropship

Line 513: oe_order_lines_all sl_child,

509: ra_cust_trx_line_gl_dist_all rctlgd,
510: ra_customer_trx_lines_all rctl,
511: oe_order_headers_all sh,
512: oe_order_lines_all sl_parent,
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 */

Line 664: oe_order_lines_all rma_line,

660: ra_cust_trx_line_gl_dist_all rctlgd,
661: ra_customer_trx_lines_all rctl,
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

Line 757: oe_order_lines_all sl_parent,

753: rma.invoice_quantity, 0),
754: sl_child.return_context,
755: sl_child.reference_line_id
756: FROM
757: oe_order_lines_all sl_parent,
758: oe_order_lines_all sl_child,
759: oe_order_headers_all sh
760: WHERE
761: sl_parent.org_id = l_ou_id

Line 758: oe_order_lines_all sl_child,

754: sl_child.return_context,
755: sl_child.reference_line_id
756: FROM
757: oe_order_lines_all sl_parent,
758: oe_order_lines_all sl_child,
759: oe_order_headers_all sh
760: WHERE
761: sl_parent.org_id = l_ou_id
762: and sl_child.org_id = l_ou_id

Line 906: oe_order_lines_all oel

902: and rctl.previous_customer_trx_id = temp.customer_trx_id
903: and not exists
904: (select 'x'
905: from cst_margin_summary t2,
906: oe_order_lines_all oel
907: where t2.source = 'RMA-INVOICE'
908: and t2.build_id = temp.build_id
909: and t2.org_id = l_ou_id
910: and temp.header_id = oel.reference_header_id

Line 1061: oe_order_lines_all sl_child,

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,
1064: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1065: WHERE cr.build_id = l_build_id

Line 1062: oe_order_lines_all sl_parent,

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,
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

Line 1174: oe_order_lines_all sl_parent,

1170: cst_margin_build cr,
1171: ap_invoice_distributions_all aid,
1172: ap_invoices_all ai,
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

Line 1175: oe_order_lines_all sl_child,

1171: ap_invoice_distributions_all aid,
1172: ap_invoices_all ai,
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

Line 1291: oe_order_lines_all rma_line,

1287: mta.reference_account -- added for ER 3007482
1288: FROM
1289: cst_margin_build cr,
1290: oe_order_headers_all rma,
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 */

Line 1391: oe_order_lines_all sl_parent,

1387: ),
1388: sl_child.return_context,
1389: sl_child.reference_line_id
1390: FROM
1391: oe_order_lines_all sl_parent,
1392: oe_order_lines_all sl_child,
1393: oe_order_headers_all sh
1394: WHERE
1395: NVL(sl_parent.org_id, -999) =

Line 1392: oe_order_lines_all sl_child,

1388: sl_child.return_context,
1389: sl_child.reference_line_id
1390: FROM
1391: oe_order_lines_all sl_parent,
1392: oe_order_lines_all sl_child,
1393: oe_order_headers_all sh
1394: WHERE
1395: NVL(sl_parent.org_id, -999) =
1396: NVL(l_ou_id, NVL(sl_parent.org_id, -999))