DBA Data[Home] [Help]

APPS.CSTPOMLD dependencies on OE_ORDER_HEADERS_ALL

Line 362: oe_order_headers_all sh,

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

Line 505: oe_order_headers_all sh,

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

Line 648: oe_order_headers_all rma,

644: FROM
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

Line 780: oe_order_headers_all rma,

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

Line 880: oe_order_headers_all sh

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

Line 1008: oe_order_headers_all rma,

1004: FROM
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

Line 1306: oe_order_headers_all sh,

1302: ),
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,

Line 1439: oe_order_headers_all sh,

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

Line 1574: oe_order_headers_all rma,

1570: mmt.primary_quantity,-1,mmt.primary_quantity,0),
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,

Line 1682: oe_order_headers_all sh

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