APPS.FTE_FPA_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 268: FROM WSH_DELIVERY_DETAILS WDD

264: WEIGHT_UOM_CODE,
265: g_wt_uom,
266: WDD.GROSS_WEIGHT,
267: WDD.INVENTORY_ITEM_ID)),0)
268: FROM WSH_DELIVERY_DETAILS WDD
269: WHERE WDD.DELIVERY_DETAIL_ID
270: IN (
271: SELECT DELIVERY_DETAIL_ID
272: FROM WSH_DELIVERY_ASSIGNMENTS

Line 1200: WSH_DELIVERY_DETAILS WDD,

1196: WDD.CURRENCY_CODE,
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

Line 1226: WSH_DELIVERY_DETAILS WDD,

1222: AND FH.BILL_STATUS <> 'OBSOLETE'
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

Line 1261: WSH_DELIVERY_DETAILS WDD,

1257: WHERE WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',NVL(WDL.PARENT_DELIVERY_LEG_ID,WDL.DELIVERY_LEG_ID),'TRUCK',WT.TRIP_ID)
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,

Line 1286: FROM WSH_DELIVERY_DETAILS

1282: AND WDD.SOURCE_LINE_ID = p_source_line_id;
1283:
1284: CURSOR C_VENDOR_INFO(p_source_line_id NUMBER) IS
1285: SELECT VENDOR_ID,SHIP_FROM_SITE_ID
1286: FROM WSH_DELIVERY_DETAILS
1287: WHERE SOURCE_LINE_ID = p_source_line_id
1288: AND ROWNUM <= 1;
1289:
1290:

Line 1558: WSH_DELIVERY_DETAILS WDD,

1554: SELECT DISTINCT WDD.SOURCE_LINE_ID,
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,

Line 1588: WSH_DELIVERY_DETAILS WDD,

1584: AND WDI.SEQUENCE_NUMBER = FH.BOL
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

Line 1623: WSH_DELIVERY_DETAILS WDD,

1619: WHERE WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',NVL(WDL.PARENT_DELIVERY_LEG_ID,WDL.DELIVERY_LEG_ID),'TRUCK',WT.TRIP_ID)
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,

Line 1649: FROM WSH_DELIVERY_DETAILS

1645:
1646:
1647: CURSOR C_VENDOR_INFO(p_source_line_id NUMBER) IS
1648: SELECT VENDOR_ID,SHIP_FROM_SITE_ID
1649: FROM WSH_DELIVERY_DETAILS
1650: WHERE SOURCE_LINE_ID = p_source_line_id
1651: AND ROWNUM <= 1;
1652:
1653: