DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on BOM_REVISIONS

Line 1704: SELECT NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn

1700: itemID IN NUMBER,
1701: revision OUT NOCOPY VARCHAR2) return boolean IS
1702:
1703: BEGIN
1704: SELECT NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn
1705: ('EXCLUDE_OPEN_HOLD', -- eco_status
1706: 'ALL', -- examine_type
1707: orgID, -- org_id
1708: itemID, -- item_id

Line 1719: NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn

1715: AND wdj.wip_entity_id = wipEntityID
1716: AND mir.organization_id = orgID
1717: AND mir.inventory_item_id = itemID
1718: AND (mir.revision =
1719: NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn
1720: ('EXCLUDE_OPEN_HOLD', -- eco_status
1721: 'ALL', -- examine_type
1722: orgID, -- org_id
1723: itemID, -- item_id