DBA Data[Home] [Help]

APPS.INV_COPY_ITEM_CP dependencies on DUAL

Line 733: FROM dual;

729:
730: -- Get next sequece value for SetProcessId
731: SELECT mtl_system_items_intf_sets_s.NEXTVAL
732: INTO l_set_process_id
733: FROM dual;
734:
735: IF(g_statement_level >= g_debug_level)
736: THEN
737: FND_LOG.string(g_statement_level

Line 955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;

951: FETCH c_item_rev_update_cursor into l_org_id, l_inv_item_id, l_revision;
952: EXIT WHEN c_item_rev_update_cursor%NOTFOUND;
953:
954: --Get the new Revision Id from Sequence.
955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
956:
957: --Update Inferface table with mandatroy Revision Id Attribute.
958: UPDATE mtl_item_revisions_interface
959: SET revision_id = l_revision_id