DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on BOM_REVISIONS

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

4964: END IF;
4965:
4966: /* Get current and new item revisions of the item in the local org */
4967: BEGIN
4968: SELECT BOM_REVISIONS.get_item_revision_fn('ALL', 'ALL', p_local_organization_id,
4969: ri.revised_item_id, SYSDATE) revision ,
4970: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
4971: ri.revised_item_id, SYSDATE) revision_id
4972: INTO l_current_local_revision, l_current_local_revision_id

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

4966: /* Get current and new item revisions of the item in the local org */
4967: BEGIN
4968: SELECT BOM_REVISIONS.get_item_revision_fn('ALL', 'ALL', p_local_organization_id,
4969: ri.revised_item_id, SYSDATE) revision ,
4970: BOM_REVISIONS.get_item_revision_id_fn('ALL', 'ALL', p_local_organization_id,
4971: ri.revised_item_id, SYSDATE) revision_id
4972: INTO l_current_local_revision, l_current_local_revision_id
4973: FROM dual;
4974: EXCEPTION