APPS.WSH_DEL_OI_CORE dependencies on SO_PICKING_HEADERS_ALL

Line 17: so_picking_headers_all soph

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
21: open order_info;

Line 46: FROM so_picking_headers_all

42: FUNCTION PICKSLIP_CLOSED (X_PICKING_HEADER_ID IN NUMBER) RETURN BOOLEAN
43: IS
44: CURSOR open_hdr IS
45: SELECT pick_slip_number
46: FROM so_picking_headers_all
47: WHERE picking_header_id = X_Picking_Header_id
48: AND status_code = 'OPEN';
49: sql_dummy number;
50:

Line 1054: so_picking_headers_all ph

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) <>
1058: (SELECT nvl(h2.org_id,-99)