DBA Data[Home] [Help]

APPS.WMS_WMSSTCON_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 170: WSH_DELIVERY_ASSIGNMENTS WDA

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 )
174: AND SOURCE_CODE = 'OE';

Line 192: WSH_DELIVERY_ASSIGNMENTS WDA

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;
196: END IF;

Line 220: WSH_DELIVERY_ASSIGNMENTS WDA

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 );
224: END IF;