DBA Data[Home] [Help]

APPS.INV_INVENTORY_ADJUSTMENT dependencies on MTL_ADJ_SYNC_WRAPPER_V

Line 192: from mtl_adj_sync_wrapper_v

188: PRIMARY_UOM,
189: SECONDARY_QUANTITY,
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)

Line 279: from mtl_adj_sync_wrapper_v

275: PRIMARY_UOM,
276: SECONDARY_QUANTITY,
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');

Line 376: from mtl_adj_sync_wrapper_v

372: PRIMARY_UOM,
373: SECONDARY_QUANTITY,
374: SECONDARY_UOM,
375: l_entity_id
376: from mtl_adj_sync_wrapper_v
377: where organization_id = p_org_id
378: AND NVL(transaction_extracted, 'N') NOT IN ('Y','P')
379: AND transaction_type_id = nvl(l_txn_type_id, transaction_type_id)
380: AND transaction_date >= trx_date_from

Line 462: from mtl_adj_sync_wrapper_v

458: PRIMARY_UOM,
459: SECONDARY_QUANTITY,
460: SECONDARY_UOM,
461: l_entity_id
462: from mtl_adj_sync_wrapper_v
463: where organization_id = p_org_id
464: AND xml_document_id = p_xml_doc_id
465: AND NVL(transaction_extracted, 'N') IN ('Y');
466: --If xml_document_id is not null then other parameters are irrelevant