APPS.CSTPMRGL dependencies on OE_ORDER_HEADERS_ALL

Line 374: oe_order_headers_all sh,

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
377: cr.build_id = l_build_id
378: AND rct.org_id = l_ou_id

Line 511: oe_order_headers_all sh,

507: FROM
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,

Line 663: oe_order_headers_all rma,

659: cst_margin_build cr,
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

Line 759: oe_order_headers_all sh

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
763: and sl_child.line_category_code = 'ORDER'

Line 1063: oe_order_headers_all sh,

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
1067: OR mmt.transaction_action_id = 9)

Line 1173: oe_order_headers_all sh,

1169: FROM
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 */

Line 1290: oe_order_headers_all rma,

1286: mta.base_transaction_value,
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,

Line 1393: oe_order_headers_all sh

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))
1397: and NVL(sl_child.org_id, -999) =