DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 1826: from oe_order_headers_all a,

1822: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;
1823:
1824: Cursor c_get_org (p_order_header_id number) is
1825: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
1826: from oe_order_headers_all a,
1827: oe_order_lines_all b
1828: where a.header_id = b.header_id
1829: and a.header_id = p_order_header_id;
1830:

Line 3539: from oe_order_headers_all a,

3535: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;
3536:
3537: Cursor c_get_org (p_order_header_id number) is
3538: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
3539: from oe_order_headers_all a,
3540: oe_order_lines_all b
3541: where a.header_id = b.header_id
3542: and a.header_id = p_order_header_id;
3543:

Line 4050: oe_order_headers_all ooh,

4046: Select max(ced.order_header_id)
4047: into l_prod_txn_rec.add_to_order_id
4048: from csd_product_transactions cpt,
4049: cs_estimate_details ced,
4050: oe_order_headers_all ooh,
4051: oe_order_types_v oot,
4052: cs_incidents_all_b sr
4053: where cpt.estimate_detail_id = ced.estimate_detail_id
4054: and cpt.repair_line_id = p_repair_line_id