APPS.WSH_DEL_OI_CORE dependencies on SO_HEADERS

Line 16: FROM so_headers_all soh,

12: declare
13: cursor order_info is
14: SELECT soh.currency_code ,
15: soh.order_category
16: FROM so_headers_all soh,
17: so_picking_headers_all soph
18: WHERE soph.picking_header_id = X_picking_header_id
19: AND soh.header_id = soph.order_header_id;
20: begin

Line 1046: -- where current org is the org on any/all orders in the so_headers view

1042:
1043: -- Name Ship_multi_org
1044: -- Purpose:
1045: -- used when checking for multi-org. Ensures order's org is same as current org
1046: -- where current org is the org on any/all orders in the so_headers view
1047:
1048: FUNCTION Ship_multi_org (X_picking_header_id in number ) return BOOLEAN is
1049: BEGIN
1050: declare

Line 1053: FROM so_headers_all h,

1049: BEGIN
1050: declare
1051: CURSOR multi_org_check is
1052: SELECT 'SHIP_DIFF_ORG'
1053: FROM so_headers_all h,
1054: so_picking_headers_all ph
1055: WHERE h.header_id = ph.order_header_id
1056: AND ph.picking_header_id = X_picking_header_id
1057: AND nvl(h.org_id,-99) <>

Line 1059: FROM so_headers h2

1055: WHERE h.header_id = ph.order_header_id
1056: AND ph.picking_header_id = X_picking_header_id
1057: AND nvl(h.org_id,-99) <>
1058: (SELECT nvl(h2.org_id,-99)
1059: FROM so_headers h2
1060: WHERE rownum = 1);
1061:
1062: x_msg_name VARCHAR2(40);
1063: