DBA Data[Home] [Help]

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 517: oe_order_headers_all sh,

513: FROM
514: cst_margin_build cr,
515: ra_cust_trx_line_gl_dist_all rctlgd,
516: ra_customer_trx_lines_all rctl,
517: oe_order_headers_all sh,
518: oe_order_lines_all sl_parent,
519: oe_order_lines_all sl_child,
520: mtl_system_items msi,
521: ra_customer_trx_all rct,

Line 677: oe_order_headers_all rma,

673: cst_margin_build cr,
674: ra_cust_trx_line_gl_dist_all rctlgd,
675: ra_customer_trx_lines_all rctl,
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

Line 779: oe_order_headers_all sh

775: sl_child.reference_line_id
776: FROM
777: oe_order_lines_all sl_parent,
778: oe_order_lines_all sl_child,
779: oe_order_headers_all sh
780: WHERE
781: sl_parent.org_id = l_ou_id
782: and sl_child.org_id = l_ou_id
783: 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 1240: oe_order_headers_all sh,

1236: cst_acct_info_v ood,
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

Line 1358: oe_order_headers_all sh,

1354: FROM
1355: cst_margin_build cr,
1356: ap_invoice_distributions_all aid,
1357: ap_invoices_all ai,
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 */

Line 1475: oe_order_headers_all rma,

1471: mta.base_transaction_value,
1472: mta.reference_account -- added for ER 3007482
1473: FROM
1474: cst_margin_build cr,
1475: oe_order_headers_all rma,
1476: oe_order_lines_all rma_line,
1477: mtl_material_transactions mmt,
1478: cst_organization_definitions cod,
1479: mtl_transaction_accounts mta,

Line 1579: oe_order_headers_all sh

1575: sl_child.reference_line_id
1576: FROM
1577: oe_order_lines_all sl_parent,
1578: oe_order_lines_all sl_child,
1579: oe_order_headers_all sh
1580: WHERE
1581: NVL(sl_parent.org_id, -999) =
1582: NVL(l_ou_id, NVL(sl_parent.org_id, -999))
1583: and NVL(sl_child.org_id, -999) =