[Home] [Help]
244: IS
245: SELECT nvl(WFC.TOTAL_AMOUNT,0),
246: WFC.CURRENCY_CODE
247: FROM
248: WSH_DELIVERY_LEGS WDL ,
249: WSH_TRIP_STOPS WT,
250: WSH_FREIGHT_COSTS WFC
251: WHERE
252: WT.STOP_ID = WDL.PICK_UP_STOP_ID
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
1206: AND (WDA.DELIVERY_ID = WDL.DELIVERY_ID OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)
1205: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1206: AND (WDA.DELIVERY_ID = WDL.DELIVERY_ID OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)
1207: AND WDD.LINE_DIRECTION = 'I'
1208: AND WDI.ENTITY_ID = WDL.DELIVERY_LEG_ID
1209: AND WDI.ENTITY_NAME = 'WSH_DELIVERY_LEGS'
1210: AND WDI.DOCUMENT_TYPE = 'BOL'
1211: AND WDI.SEQUENCE_NUMBER = p_bol_no;
1212:
1213: CURSOR C_SOURCE_LINE_BOLS ( p_source_line_id NUMBER,p_bol VARCHAR2)
1216: SELECT distinct wdl.delivery_leg_id,
1217: decode( (select distinct WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
1218: where
1219: WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
1220: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
1221: AND WDI.SEQUENCE_NUMBER = FH.BOL
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
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
1232: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1254: WDD.WEIGHT_UOM_CODE,
1255: WDD.CURRENCY_CODE,
1256: (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI
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,
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,
1267: MTL_CATEGORIES_KFV C,
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
1564: WHERE
1579: SELECT distinct wdl.delivery_leg_id,
1580: decode( (select WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH
1581: where
1582: WDI.ENTITY_ID = DECODE(WT.MODE_OF_TRANSPORT,'LTL',WDL.DELIVERY_LEG_ID,'TRUCK',WT.TRIP_ID)
1583: AND WDI.ENTITY_NAME = DECODE(WT.MODE_OF_TRANSPORT,'LTL','WSH_DELIVERY_LEGS','TRUCK','WSH_TRIPS')
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
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
1594: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1616: WDD.WEIGHT_UOM_CODE,
1617: WDD.CURRENCY_CODE,
1618: (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI
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,
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,
1629: MTL_CATEGORIES_KFV C,