DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on BOM_REVISIONS

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

1691: itemID IN NUMBER,
1692: revision OUT NOCOPY VARCHAR2) return boolean IS
1693:
1694: BEGIN
1695: SELECT NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn
1696: ('EXCLUDE_OPEN_HOLD', -- eco_status
1697: 'ALL', -- examine_type
1698: orgID, -- org_id
1699: itemID, -- item_id

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

1706: AND wdj.wip_entity_id = wipEntityID
1707: AND mir.organization_id = orgID
1708: AND mir.inventory_item_id = itemID
1709: AND (mir.revision =
1710: NVL(wdj.bom_revision, bom_revisions.get_item_revision_fn
1711: ('EXCLUDE_OPEN_HOLD', -- eco_status
1712: 'ALL', -- examine_type
1713: orgID, -- org_id
1714: itemID, -- item_id