DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on BOM_REVISIONS

Line 5095: SELECT BOM_REVISIONS.get_item_revision_fn('ALL', 'ALL', p_local_organization_id,

5091: END IF;
5092:
5093: /* Get current and new item revisions of the item in the local org */
5094: BEGIN
5095: SELECT BOM_REVISIONS.get_item_revision_fn('ALL', 'ALL', p_local_organization_id,
5096: ri.revised_item_id, SYSDATE) revision ,
5097: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
5098: ri.revised_item_id, SYSDATE) revision_id
5099: INTO l_current_local_revision, l_current_local_revision_id

Line 5097: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,

5093: /* Get current and new item revisions of the item in the local org */
5094: BEGIN
5095: SELECT BOM_REVISIONS.get_item_revision_fn('ALL', 'ALL', p_local_organization_id,
5096: ri.revised_item_id, SYSDATE) revision ,
5097: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
5098: ri.revised_item_id, SYSDATE) revision_id
5099: INTO l_current_local_revision, l_current_local_revision_id
5100: FROM dual;
5101: EXCEPTION