DBA Data[Home] [Help]

APPS.INVIDIT2 dependencies on DUAL

Line 443: into l_revision_id from dual;

439: BEGIN
440: if (X_event = 'INSERT') then
441:
442: select mtl_item_revisions_b_s.nextval
443: into l_revision_id from dual;
444:
445: insert into mtl_item_revisions_b
446: (inventory_item_id,
447: organization_id,

Line 510: into l_revision_id from dual;

506:
507: elsif (X_event = 'ORG_ASSIGN') then
508:
509: select mtl_item_revisions_b_s.nextval
510: into l_revision_id from dual;
511:
512: insert into mtl_item_revisions_b
513: (inventory_item_id,
514: organization_id,

Line 785: dual;

781: -1,
782: SYSDATE,
783: -1
784: FROM
785: dual;
786:
787: --* Added for Bug 4491340
788: IF SQL%ROWCOUNT > 0 THEN
789: l_cat_ins_upd := TRUE;