APPS.FTE_FPA_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 272: FROM WSH_DELIVERY_ASSIGNMENTS

268: FROM WSH_DELIVERY_DETAILS WDD
269: WHERE WDD.DELIVERY_DETAIL_ID
270: IN (
271: SELECT DELIVERY_DETAIL_ID
272: FROM WSH_DELIVERY_ASSIGNMENTS
273: START WITH DELIVERY_DETAIL_ID = p_detail_id
274: CONNECT BY PRIOR PARENT_DELIVERY_DETAIL_ID= DELIVERY_DETAIL_ID
275: );
276:

Line 287: FROM WSH_DELIVERY_ASSIGNMENTS

283: FROM
284: (SELECT
285: DELIVERY_DETAIL_ID,
286: LEVEL
287: FROM WSH_DELIVERY_ASSIGNMENTS
288: START WITH DELIVERY_DETAIL_ID = p_detail_id
289: CONNECT BY PRIOR PARENT_DELIVERY_DETAIL_ID = DELIVERY_DETAIL_ID ORDER BY LEVEL DESC
290: ) A
291: WHERE ROWNUM = 1;

Line 1201: WSH_DELIVERY_ASSIGNMENTS WDA,

1197: WDD.WEIGHT_UOM_CODE,
1198: WDD.RCV_SHIPMENT_LINE_ID
1199: FROM
1200: WSH_DELIVERY_DETAILS WDD,
1201: WSH_DELIVERY_ASSIGNMENTS WDA,
1202: WSH_DELIVERY_LEGS WDL,
1203: WSH_DOCUMENT_INSTANCES WDI
1204: WHERE
1205: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID

Line 1227: WSH_DELIVERY_ASSIGNMENTS WDA,

1223: AND FH.BILL_STATUS = decode(FH.BOL,p_bol,FH.BILL_STATUS,'APPROVED')
1224: ),NULL,1,0) bol_flag
1225: FROM
1226: WSH_DELIVERY_DETAILS WDD,
1227: WSH_DELIVERY_ASSIGNMENTS WDA,
1228: WSH_DELIVERY_LEGS WDL,
1229: WSH_TRIP_STOPS WTS,
1230: WSH_TRIPS WT
1231: WHERE

Line 1262: WSH_DELIVERY_ASSIGNMENTS WDA,

1258: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
1259: ) SEQUENCE_NUMBER
1260: FROM
1261: WSH_DELIVERY_DETAILS WDD,
1262: WSH_DELIVERY_ASSIGNMENTS WDA,
1263: WSH_DELIVERY_LEGS WDL,
1264: WSH_TRIP_STOPS WTS,
1265: WSH_TRIPS WT,
1266: MTL_ITEM_CATEGORIES MIC,

Line 1559: WSH_DELIVERY_ASSIGNMENTS WDA,

1555: WDD.CURRENCY_CODE,
1556: WDD.WEIGHT_UOM_CODE
1557: FROM
1558: WSH_DELIVERY_DETAILS WDD,
1559: WSH_DELIVERY_ASSIGNMENTS WDA,
1560: WSH_DELIVERY_LEGS WDL,
1561: WSH_TRIP_STOPS WTS,
1562: WSH_TRIPS WT,
1563: WSH_DOCUMENT_INSTANCES WDI

Line 1589: WSH_DELIVERY_ASSIGNMENTS WDA,

1585: AND FH.BILL_STATUS = decode(FH.BOL,p_bol,FH.BILL_STATUS,'APPROVED')
1586: ),NULL,1,0) bol_flag
1587: FROM
1588: WSH_DELIVERY_DETAILS WDD,
1589: WSH_DELIVERY_ASSIGNMENTS WDA,
1590: WSH_DELIVERY_LEGS WDL,
1591: WSH_TRIP_STOPS WTS,
1592: WSH_TRIPS WT
1593: WHERE

Line 1624: WSH_DELIVERY_ASSIGNMENTS WDA,

1620: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
1621: ) SEQUENCE_NUMBER
1622: FROM
1623: WSH_DELIVERY_DETAILS WDD,
1624: WSH_DELIVERY_ASSIGNMENTS WDA,
1625: WSH_DELIVERY_LEGS WDL,
1626: WSH_TRIP_STOPS WTS,
1627: WSH_TRIPS WT,
1628: MTL_ITEM_CATEGORIES MIC,