APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 286: OE_ORDER_LINES_ALL L

282: ,-999),
283: L.LINE_ID
284: INTO L_LINE_SET_ID,L_LINE_ID
285: FROM
286: OE_ORDER_LINES_ALL L
287: WHERE L.LINE_ID = C_SRC_LINE_ID;
288: SELECT
289: SUM(WDD.REQUESTED_QUANTITY) - NVL(SUM(WDD.SHIPPED_QUANTITY)
290: ,0)

Line 294: OE_ORDER_LINES_ALL L

290: ,0)
291: INTO TOTAL_UNSHIPPED_QUANTITY
292: FROM
293: WSH_DELIVERY_DETAILS WDD,
294: OE_ORDER_LINES_ALL L
295: WHERE WDD.SOURCE_LINE_ID = L.LINE_ID
296: AND WDD.SOURCE_CODE = 'OE'
297: AND WDD.CONTAINER_FLAG = 'N'
298: AND ( ( L.LINE_SET_ID is not null

Line 552: OE_ORDER_LINES_ALL OLA

548: FROM
549: HZ_PARTY_SITES PS,
550: HZ_CUST_ACCT_SITES_ALL CA,
551: HZ_CUST_SITE_USES_ALL SU,
552: OE_ORDER_LINES_ALL OLA
553: WHERE OLA.LINE_ID = CF_OE_LINE_ID
554: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
555: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
556: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID;

Line 588: OE_ORDER_LINES_ALL OLA

584: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
585: FROM
586: WSH_DELIVERY_DETAILS WDD,
587: WSH_DELIVERY_ASSIGNMENTS_V WDA,
588: OE_ORDER_LINES_ALL OLA
589: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
590: AND NVL(WDD.CONTAINER_FLAG
591: ,'N') = 'N'
592: AND WDA.DELIVERY_ID = P_DELIVERY_ID

Line 611: OE_ORDER_LINES_ALL OLA

607: INTO OE_LINE_ID
608: FROM
609: WSH_DELIVERY_DETAILS WDD,
610: WSH_DELIVERY_ASSIGNMENTS_V WDA,
611: OE_ORDER_LINES_ALL OLA
612: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
613: AND WDD.CONTAINER_FLAG = 'N'
614: AND WDA.DELIVERY_ID = P_DELIVERY_ID
615: AND WDA.DELIVERY_ID is not null

Line 761: OE_ORDER_LINES_ALL OLA

757: HZ_PARTY_SITES PS,
758: HZ_CUST_ACCT_SITES_ALL CA,
759: HZ_CUST_SITE_USES_ALL SU,
760: HZ_PARTIES HP,
761: OE_ORDER_LINES_ALL OLA
762: WHERE OLA.LINE_ID = F_OE_LINE_ID
763: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
764: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
765: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID

Line 800: L_LINE_TAX_CODE OE_ORDER_LINES_ALL.TAX_CODE%TYPE;

796: END F_BILL_TO_CUST_NAME1FORMULA;
797: FUNCTION CF_LINE_TAX_CODE1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
798: BEGIN
799: DECLARE
800: L_LINE_TAX_CODE OE_ORDER_LINES_ALL.TAX_CODE%TYPE;
801: BEGIN
802: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;
803: IF CP_SOURCE_CODE = 'OKE' THEN
804: L_LINE_TAX_CODE := '';

Line 810: OE_ORDER_LINES_ALL

806: SELECT
807: TAX_CODE
808: INTO L_LINE_TAX_CODE
809: FROM
810: OE_ORDER_LINES_ALL
811: WHERE LINE_ID = F_OE_LINE_ID;
812: IF SQL%NOTFOUND THEN
813: RETURN (NULL);
814: END IF;

Line 924: OE_ORDER_LINES_ALL OLA

920: FROM
921: HZ_PARTY_SITES PS,
922: HZ_CUST_ACCT_SITES_ALL CA,
923: HZ_CUST_SITE_USES_ALL SU,
924: OE_ORDER_LINES_ALL OLA
925: WHERE OLA.LINE_ID = F_OE_LINE_ID
926: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
927: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
928: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID;

Line 960: OE_ORDER_LINES_ALL OLA

956: INTO OE_LINE_ID,SHP_TO_CONTACT_ID,BILL_TO_CONTACT_ID
957: FROM
958: WSH_DELIVERY_DETAILS WDD,
959: WSH_DELIVERY_ASSIGNMENTS_V WDA,
960: OE_ORDER_LINES_ALL OLA
961: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
962: AND NVL(WDD.CONTAINER_FLAG
963: ,'N') = 'N'
964: AND WDA.DELIVERY_ID = P_DELIVERY_ID