APPS.INV_INVENTORY_ADJUSTMENT dependencies on WMS_DEPLOY

Line 165: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,

161: CATEGORY,
162: CATEGORY_ID,
163: WAREHOUSE,
164: ORGANIZATION_ID,
165: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,
166: ITEM_DESCRIPTION,
167: INVENTORY_ITEM_ID,
168: REVISION,
169: SUBINVENTORY,

Line 194: AND wms_deploy.get_client_code(inventory_item_id) = p_client_code

190: SECONDARY_UOM,
191: l_entity_id
192: from mtl_adj_sync_wrapper_v
193: where organization_id = p_org_id
194: AND wms_deploy.get_client_code(inventory_item_id) = p_client_code
195: AND NVL(transaction_extracted, 'N') NOT IN ('Y','P')
196: AND transaction_type_id = nvl(l_txn_type_id, transaction_type_id)
197: AND transaction_date >= trx_date_from
198: AND transaction_date < trx_date_to + 1; -- Added 1 as the input dates are truncated.

Line 252: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,

248: CATEGORY,
249: CATEGORY_ID,
250: WAREHOUSE,
251: ORGANIZATION_ID,
252: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,
253: ITEM_DESCRIPTION,
254: INVENTORY_ITEM_ID,
255: REVISION,
256: SUBINVENTORY,

Line 281: AND wms_deploy.get_client_code(inventory_item_id) = p_client_code

277: SECONDARY_UOM,
278: l_entity_id
279: from mtl_adj_sync_wrapper_v
280: where organization_id = p_org_id
281: AND wms_deploy.get_client_code(inventory_item_id) = p_client_code
282: AND xml_document_id = p_xml_doc_id
283: AND NVL(transaction_extracted, 'N') IN ('Y');
284: --If xml_document_id is not null then other parameters are irrelevant
285: --AND transaction_type_id = nvl(l_txn_type_id, transaction_type_id);

Line 349: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,

345: CATEGORY,
346: CATEGORY_ID,
347: WAREHOUSE,
348: ORGANIZATION_ID,
349: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,
350: ITEM_DESCRIPTION,
351: INVENTORY_ITEM_ID,
352: REVISION,
353: SUBINVENTORY,

Line 435: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,

431: CATEGORY,
432: CATEGORY_ID,
433: WAREHOUSE,
434: ORGANIZATION_ID,
435: WMS_DEPLOY.GET_CLIENT_ITEM(ORGANIZATION_ID,INVENTORY_ITEM_ID) ITEM,
436: ITEM_DESCRIPTION,
437: INVENTORY_ITEM_ID,
438: REVISION,
439: SUBINVENTORY,