APPS.FTE_FPA_UTIL dependencies on WSH_DOCUMENT_INSTANCES

Line 1203: WSH_DOCUMENT_INSTANCES WDI

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)
1207: AND WDD.LINE_DIRECTION = 'I'

Line 1217: decode( (select distinct WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH

1213: CURSOR C_SOURCE_LINE_BOLS ( p_source_line_id NUMBER,p_bol VARCHAR2)
1214: IS
1215: SELECT SUM(A.bol_flag) FROM (
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

Line 1256: (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI

1252: DECODE(WDA.PARENT_DELIVERY_DETAIL_ID,NULL,'Y','N') AS CONTAINER_FLAG,
1253: WDD.GROSS_WEIGHT,
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

Line 1563: WSH_DOCUMENT_INSTANCES WDI

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
1565: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1566: AND WDD.LINE_DIRECTION = 'I'
1567: AND WDA.DELIVERY_ID = WDL.DELIVERY_ID

Line 1580: decode( (select WDI.sequence_number from wsh_document_instances WDI,FTE_INVOICE_HEADERS FH

1576: CURSOR C_SOURCE_LINE_BOLS ( p_source_line_id NUMBER,p_bol VARCHAR2)
1577: IS
1578: SELECT SUM(A.bol_flag) FROM (
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

Line 1618: (SELECT WDI.SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WDI

1614: DECODE(WDA.PARENT_DELIVERY_DETAIL_ID,NULL,'Y','N') AS CONTAINER_FLAG,
1615: WDD.GROSS_WEIGHT,
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