DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_EXISTING_DOCS dependencies on DUAL

Line 568: FROM DUAL

564: g_R12_MIGRATION_PROGRAM, -- last_update_program
565: sysdate, -- last_update_date
566: g_R12_UPGRADE_USER, -- created_by
567: sysdate -- creation_date
568: FROM DUAL
569: WHERE gRecreateAttribRow(i) = 'Y'
570: AND NOT EXISTS
571: (SELECT /*+ INDEX(POAT, PO_ATTRIBUTE_VALUES_U2) */
572: 'Attr row already exists'

Line 667: FROM DUAL

663: g_R12_MIGRATION_PROGRAM, -- last_update_program
664: sysdate, -- last_update_date
665: g_R12_UPGRADE_USER, -- created_by
666: sysdate -- creation_date
667: FROM DUAL
668: WHERE gRecreateAttribTLPRow(i) = 'Y'
669: AND gInvItemIds(i) = NULL_ID -- Description based non catalog item
670: AND NOT EXISTS
671: (SELECT /*+ INDEX(POATLP, PO_ATTRIBUTE_VALUES_TLP_U2) */