APPS.WMS_WMSSTCON_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 164: WSH_DELIVERY_DETAILS

160: SELECT
161: count(SOURCE_HEADER_ID)
162: INTO MCOUNT
163: FROM
164: WSH_DELIVERY_DETAILS
165: WHERE DELIVERY_DETAIL_ID in (
166: SELECT
167: WDA.DELIVERY_DETAIL_ID
168: FROM

Line 169: WSH_DELIVERY_DETAILS WDD,

165: WHERE DELIVERY_DETAIL_ID in (
166: SELECT
167: WDA.DELIVERY_DETAIL_ID
168: FROM
169: WSH_DELIVERY_DETAILS WDD,
170: WSH_DELIVERY_ASSIGNMENTS WDA
171: WHERE WDD.ORGANIZATION_ID = P_ORG_ID
172: AND WDD.LPN_ID = INMULTIPLESOFORMULA.LPN_ID
173: AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID )

Line 191: WSH_DELIVERY_DETAILS WDD,

187: SELECT
188: count(WDA.DELIVERY_ID)
189: INTO MCOUNT
190: FROM
191: WSH_DELIVERY_DETAILS WDD,
192: WSH_DELIVERY_ASSIGNMENTS WDA
193: WHERE WDD.ORGANIZATION_ID = P_ORG_ID
194: AND WDD.LPN_ID = INMULTIPLEDELIVERYFORMULA.LPN_ID
195: AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID;

Line 219: WSH_DELIVERY_DETAILS WDD,

215: AND WDL.DELIVERY_ID in (
216: SELECT
217: WDA.DELIVERY_ID
218: FROM
219: WSH_DELIVERY_DETAILS WDD,
220: WSH_DELIVERY_ASSIGNMENTS WDA
221: WHERE WDD.ORGANIZATION_ID = P_ORG_ID
222: AND WDD.LPN_ID = INMULTIPLETRIPFORMULA.LPN_ID
223: AND WDD.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID );