DBA Data[Home] [Help]

APPS.INV_COPY_ITEM_CP dependencies on DUAL

Line 731: FROM dual;

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

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

931: FETCH c_item_rev_update_cursor into l_org_id, l_inv_item_id, l_revision;
932: EXIT WHEN c_item_rev_update_cursor%NOTFOUND;
933:
934: --Get the new Revision Id from Sequence.
935: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
936:
937: --Update Inferface table with mandatroy Revision Id Attribute.
938: UPDATE mtl_item_revisions_interface
939: SET revision_id = l_revision_id