APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1334: OE_ORDER_HEADERS_ALL BH,

1330: TO_CHAR(BH.ORDER_NUMBER),
1331: RE.FULL_NAME
1332: INTO ORDER_NUMBER,REQ_NAME
1333: FROM
1334: OE_ORDER_HEADERS_ALL BH,
1335: PO_REQUISITION_HEADERS_ALL RH,
1336: HR_EMPLOYEES RE
1337: WHERE RH.TYPE_LOOKUP_CODE = 'INTERNAL'
1338: AND RH.PREPARER_ID = RE.EMPLOYEE_ID

Line 1345: from oe_order_HEADERS_ALL bh,

1341: AND BH.ORDER_SOURCE_ID = 10;*/
1342:
1343: select to_char(bh.order_number),re.full_name
1344: into order_number, req_name
1345: from oe_order_HEADERS_ALL bh,
1346: oe_order_lines_all ool,
1347: po_requisition_lines_all pll,
1348: HR_EMPLOYEES re
1349: where pll.SOURCE_TYPE_CODE = 'INVENTORY'