DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 301: OE_ORDER_LINES_ALL L

297: ,-999),
298: L.LINE_ID
299: INTO L_LINE_SET_ID,L_LINE_ID
300: FROM
301: OE_ORDER_LINES_ALL L
302: WHERE L.LINE_ID = C_SRC_LINE_ID;
303: SELECT
304: SUM(WDD.REQUESTED_QUANTITY) - NVL(SUM(WDD.SHIPPED_QUANTITY)
305: ,0)

Line 309: OE_ORDER_LINES_ALL L

305: ,0)
306: INTO TOTAL_UNSHIPPED_QUANTITY
307: FROM
308: WSH_DELIVERY_DETAILS WDD,
309: OE_ORDER_LINES_ALL L
310: WHERE WDD.SOURCE_LINE_ID = L.LINE_ID
311: AND WDD.SOURCE_CODE = 'OE'
312: AND WDD.CONTAINER_FLAG = 'N'
313: AND ( ( L.LINE_SET_ID is not null

Line 600: OE_ORDER_LINES_ALL OLA

596: FROM
597: HZ_PARTY_SITES PS,
598: HZ_CUST_ACCT_SITES_ALL CA,
599: HZ_CUST_SITE_USES_ALL SU,
600: OE_ORDER_LINES_ALL OLA
601: WHERE OLA.LINE_ID = CF_OE_LINE_ID
602: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
603: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
604: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID;

Line 668: OE_ORDER_LINES_ALL OLA

664: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
665: FROM
666: WSH_DELIVERY_DETAILS WDD,
667: WSH_DELIVERY_ASSIGNMENTS_V WDA,
668: OE_ORDER_LINES_ALL OLA
669: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
670: AND NVL(WDD.CONTAINER_FLAG
671: ,'N') = 'N'
672: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 691: OE_ORDER_LINES_ALL OLA

687: INTO OE_LINE_ID
688: FROM
689: WSH_DELIVERY_DETAILS WDD,
690: WSH_DELIVERY_ASSIGNMENTS_V WDA,
691: OE_ORDER_LINES_ALL OLA
692: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
693: AND WDD.CONTAINER_FLAG = 'N'
694: AND WDA.DELIVERY_ID = P_DELIVERY_ID
695: AND WDA.DELIVERY_ID is not null

Line 841: OE_ORDER_LINES_ALL OLA

837: HZ_PARTY_SITES PS,
838: HZ_CUST_ACCT_SITES_ALL CA,
839: HZ_CUST_SITE_USES_ALL SU,
840: HZ_PARTIES HP,
841: OE_ORDER_LINES_ALL OLA
842: WHERE OLA.LINE_ID = F_OE_LINE_ID
843: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
844: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
845: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID

Line 914: L_LINE_TAX_CODE OE_ORDER_LINES_ALL.TAX_CODE%TYPE;

910: END F_BILL_TO_CUST_NAME1FORMULA;
911: FUNCTION CF_LINE_TAX_CODE1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
912: BEGIN
913: DECLARE
914: L_LINE_TAX_CODE OE_ORDER_LINES_ALL.TAX_CODE%TYPE;
915: BEGIN
916: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;
917: IF CP_SOURCE_CODE = 'OKE' THEN
918: L_LINE_TAX_CODE := '';

Line 924: OE_ORDER_LINES_ALL

920: SELECT
921: TAX_CODE
922: INTO L_LINE_TAX_CODE
923: FROM
924: OE_ORDER_LINES_ALL
925: WHERE LINE_ID = F_OE_LINE_ID;
926: IF SQL%NOTFOUND THEN
927: RETURN (NULL);
928: END IF;

Line 1093: OE_ORDER_LINES_ALL OLA

1089: FROM
1090: HZ_PARTY_SITES PS,
1091: HZ_CUST_ACCT_SITES_ALL CA,
1092: HZ_CUST_SITE_USES_ALL SU,
1093: OE_ORDER_LINES_ALL OLA
1094: WHERE OLA.LINE_ID = F_OE_LINE_ID
1095: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
1096: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
1097: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID;

Line 1161: OE_ORDER_LINES_ALL OLA

1157: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
1158: FROM
1159: WSH_DELIVERY_DETAILS WDD,
1160: WSH_DELIVERY_ASSIGNMENTS_V WDA,
1161: OE_ORDER_LINES_ALL OLA
1162: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1163: AND NVL(WDD.CONTAINER_FLAG
1164: ,'N') = 'N'
1165: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 1346: oe_order_lines_all ool,

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'
1350: AND pll.to_person_id = re.employee_id