eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_GTIN_PVT dependencies on EGO_UCCNET_EVENTS

Line 340: FROM EGO_UCCNET_EVENTS

336: NOT EXISTS
337: (
338: SELECT
339: 1
340: FROM EGO_UCCNET_EVENTS
341: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
342: AND ORGANIZATION_ID = p_org_id
343: AND ADDRESS_ID = p_address_id
344: AND PARENT_GTIN = 0

Line 357: FROM EGO_UCCNET_EVENTS

353: AND NOT EXISTS
354: (
355: SELECT
356: 1
357: FROM EGO_UCCNET_EVENTS
358: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
359: AND ORGANIZATION_ID = p_org_id
360: AND PARENT_GTIN = 0
361: AND EVENT_TYPE = 'PUBLICATION'

Line 399: FROM EGO_UCCNET_EVENTS

395: EXISTS
396: (
397: SELECT
398: 'Y'
399: FROM EGO_UCCNET_EVENTS
400: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
401: AND ORGANIZATION_ID = p_org_id
402: AND ADDRESS_ID = p_address_id
403: AND PARENT_GTIN = 0

Line 411: FROM EGO_UCCNET_EVENTS

407: AND NOT EXISTS
408: (
409: SELECT
410: 1
411: FROM EGO_UCCNET_EVENTS
412: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
413: AND ORGANIZATION_ID = p_org_id
414: AND PARENT_GTIN = 0
415: AND EVENT_TYPE = 'PUBLICATION'

Line 453: FROM EGO_UCCNET_EVENTS UE

449: WHERE EXISTS
450: (
451: SELECT
452: 1
453: FROM EGO_UCCNET_EVENTS UE
454: WHERE UE.EVENT_ROW_ID =
455: (
456: SELECT
457: MAX(EVENT_ROW_ID)

Line 458: FROM EGO_UCCNET_EVENTS

454: WHERE UE.EVENT_ROW_ID =
455: (
456: SELECT
457: MAX(EVENT_ROW_ID)
458: FROM EGO_UCCNET_EVENTS
459: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
460: AND ORGANIZATION_ID = p_org_id
461: AND ADDRESS_ID = p_address_id
462: AND PARENT_GTIN = 0

Line 471: FROM EGO_UCCNET_EVENTS

467: AND NOT EXISTS
468: (
469: SELECT
470: 1
471: FROM EGO_UCCNET_EVENTS
472: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
473: AND ORGANIZATION_ID = p_org_id
474: AND ADDRESS_ID = p_address_id
475: AND PARENT_GTIN = 0

Line 496: FROM EGO_UCCNET_EVENTS

492: AND NOT EXISTS
493: (
494: SELECT
495: 1
496: FROM EGO_UCCNET_EVENTS
497: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
498: AND ORGANIZATION_ID = p_org_id
499: AND PARENT_GTIN = 0
500: AND EVENT_TYPE = 'PUBLICATION'

Line 511: EGO_UCCNET_EVENTS EV2,

507: (
508: SELECT
509: NVL(MAX(EICA.LAST_UPDATE_DATE) , TO_DATE('01-01-1998', 'MM-DD-YYYY'))
510: FROM EGO_ITEM_CUST_ATTRS_B EICA,
511: EGO_UCCNET_EVENTS EV2,
512: HZ_CUST_ACCT_SITES_ALL HCAS
513: WHERE EV2.BATCH_ID = UE.BATCH_ID
514: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
515: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID

Line 527: EGO_UCCNET_EVENTS EV2

523: (
524: SELECT
525: NVL(MAX(TP_NEUTRAL_UPDATE_DATE), TO_DATE('01-01-1998', 'MM-DD-YYYY'))
526: FROM EGO_ITEM_GTN_ATTRS_B EGA2,
527: EGO_UCCNET_EVENTS EV2
528: WHERE EV2.BATCH_ID = UE.BATCH_ID
529: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
530: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
531: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 551: EGO_UCCNET_EVENTS EV2,

547: END
548: ) AS LAST_UPDATE_DATE
549: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
550: EGO_ITEM_TP_ATTRS_EXT_TL tl,
551: EGO_UCCNET_EVENTS EV2,
552: HZ_CUST_ACCT_SITES_ALL HCAS
553: WHERE EV2.BATCH_ID = UE.BATCH_ID
554: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
555: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID

Line 602: FROM EGO_UCCNET_EVENTS UE

598: WHERE EXISTS
599: (
600: SELECT
601: 1
602: FROM EGO_UCCNET_EVENTS UE
603: WHERE UE.EVENT_ROW_ID =
604: (
605: SELECT
606: MAX(EVENT_ROW_ID)

Line 607: FROM EGO_UCCNET_EVENTS

603: WHERE UE.EVENT_ROW_ID =
604: (
605: SELECT
606: MAX(EVENT_ROW_ID)
607: FROM EGO_UCCNET_EVENTS
608: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
609: AND ORGANIZATION_ID = p_org_id
610: AND ADDRESS_ID = p_address_id
611: AND PARENT_GTIN = 0

Line 620: FROM EGO_UCCNET_EVENTS

616: AND NOT EXISTS
617: (
618: SELECT
619: 1
620: FROM EGO_UCCNET_EVENTS
621: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
622: AND ORGANIZATION_ID = p_org_id
623: AND ADDRESS_ID = p_address_id
624: AND PARENT_GTIN = 0

Line 645: FROM EGO_UCCNET_EVENTS

641: AND NOT EXISTS
642: (
643: SELECT
644: 1
645: FROM EGO_UCCNET_EVENTS
646: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
647: AND ORGANIZATION_ID = p_org_id
648: AND PARENT_GTIN = 0
649: AND EVENT_TYPE = 'PUBLICATION'

Line 660: EGO_UCCNET_EVENTS EV2,

656: (
657: SELECT
658: NVL(MAX(EICA.LAST_UPDATE_DATE) , TO_DATE('01-01-1998', 'MM-DD-YYYY'))
659: FROM EGO_ITEM_CUST_ATTRS_B EICA,
660: EGO_UCCNET_EVENTS EV2,
661: HZ_CUST_ACCT_SITES_ALL HCAS
662: WHERE EV2.BATCH_ID = UE.BATCH_ID
663: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
664: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID

Line 676: EGO_UCCNET_EVENTS EV2

672: (
673: SELECT
674: NVL(MAX(TP_NEUTRAL_UPDATE_DATE), TO_DATE('01-01-1998', 'MM-DD-YYYY'))
675: FROM EGO_ITEM_GTN_ATTRS_B EGA2,
676: EGO_UCCNET_EVENTS EV2
677: WHERE EV2.BATCH_ID = UE.BATCH_ID
678: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
679: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID
680: AND EV2.ADDRESS_ID = UE.ADDRESS_ID

Line 700: EGO_UCCNET_EVENTS EV2,

696: END
697: ) AS LAST_UPDATE_DATE
698: FROM EGO_ITEM_TP_ATTRS_EXT_B b,
699: EGO_ITEM_TP_ATTRS_EXT_TL tl,
700: EGO_UCCNET_EVENTS EV2,
701: HZ_CUST_ACCT_SITES_ALL HCAS
702: WHERE EV2.BATCH_ID = UE.BATCH_ID
703: AND EV2.TOP_ITEM_ID = UE.INVENTORY_ITEM_ID
704: AND EV2.ORGANIZATION_ID = UE.ORGANIZATION_ID

Line 750: FROM EGO_UCCNET_EVENTS UE

746: WHERE EXISTS
747: (
748: SELECT
749: 1
750: FROM EGO_UCCNET_EVENTS UE
751: WHERE UE.EVENT_ROW_ID =
752: (
753: SELECT
754: MAX(EVENT_ROW_ID)

Line 755: FROM EGO_UCCNET_EVENTS

751: WHERE UE.EVENT_ROW_ID =
752: (
753: SELECT
754: MAX(EVENT_ROW_ID)
755: FROM EGO_UCCNET_EVENTS
756: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
757: AND ORGANIZATION_ID = p_org_id
758: AND ADDRESS_ID = p_address_id
759: AND PARENT_GTIN = 0

Line 768: FROM EGO_UCCNET_EVENTS

764: AND NOT EXISTS
765: (
766: SELECT
767: 1
768: FROM EGO_UCCNET_EVENTS
769: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
770: AND ORGANIZATION_ID = p_org_id
771: AND ADDRESS_ID = p_address_id
772: AND PARENT_GTIN = 0

Line 793: FROM EGO_UCCNET_EVENTS

789: AND NOT EXISTS
790: (
791: SELECT
792: 1
793: FROM EGO_UCCNET_EVENTS
794: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
795: AND ORGANIZATION_ID = p_org_id
796: AND PARENT_GTIN = 0
797: AND EVENT_TYPE = 'PUBLICATION'

Line 841: FROM EGO_UCCNET_EVENTS

837: WHERE EXISTS
838: (
839: SELECT
840: 1
841: FROM EGO_UCCNET_EVENTS
842: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
843: AND ORGANIZATION_ID = p_org_id
844: AND ADDRESS_ID = p_address_id
845: AND PARENT_GTIN = 0

Line 854: FROM EGO_UCCNET_EVENTS

850: AND NOT EXISTS
851: (
852: SELECT
853: 1
854: FROM EGO_UCCNET_EVENTS
855: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
856: AND ORGANIZATION_ID = p_org_id
857: AND PARENT_GTIN = 0
858: AND EVENT_TYPE = 'PUBLICATION'

Line 900: FROM ego_uccnet_events

896: WHERE EXISTS
897: (
898: SELECT
899: 1
900: FROM ego_uccnet_events
901: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
902: AND ORGANIZATION_ID = p_org_id
903: AND EVENT_TYPE = 'PUBLICATION'
904: AND PARENT_GTIN = 0

Line 1070: FROM EGO_UCCNET_EVENTS

1066: WHERE NOT EXISTS
1067: (
1068: SELECT
1069: 1
1070: FROM EGO_UCCNET_EVENTS
1071: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1072: AND ORGANIZATION_ID = p_org_id
1073: AND EVENT_TYPE = 'REGISTRATION'
1074: AND

Line 1109: FROM EGO_UCCNET_EVENTS

1105: WHERE EXISTS
1106: (
1107: SELECT
1108: 1
1109: FROM EGO_UCCNET_EVENTS
1110: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1111: AND ORGANIZATION_ID = p_org_id
1112: AND EVENT_TYPE = 'REGISTRATION'
1113: AND DISPOSITION_CODE IS NULL

Line 1145: FROM EGO_UCCNET_EVENTS UE,

1141: WHERE EXISTS
1142: (
1143: SELECT
1144: 1
1145: FROM EGO_UCCNET_EVENTS UE,
1146: EGO_ITEM_GTN_ATTRS_B GA
1147: WHERE UE.EVENT_ROW_ID =
1148: (
1149: SELECT

Line 1151: FROM EGO_UCCNET_EVENTS

1147: WHERE UE.EVENT_ROW_ID =
1148: (
1149: SELECT
1150: max(EVENT_ROW_ID)
1151: FROM EGO_UCCNET_EVENTS
1152: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1153: AND ORGANIZATION_ID = p_org_id
1154: AND EVENT_TYPE = 'REGISTRATION'
1155: AND EVENT_ACTION IN ('ADD', 'CHANGE', 'CORRECT')

Line 1162: FROM EGO_UCCNET_EVENTS

1158: AND NOT EXISTS
1159: (
1160: SELECT
1161: 1
1162: FROM EGO_UCCNET_EVENTS
1163: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1164: AND ORGANIZATION_ID = p_org_id
1165: AND EVENT_TYPE = 'REGISTRATION'
1166: AND DISPOSITION_CODE IS NULL

Line 1205: FROM EGO_UCCNET_EVENTS UE,

1201: WHERE EXISTS
1202: (
1203: SELECT
1204: 1
1205: FROM EGO_UCCNET_EVENTS UE,
1206: EGO_ITEM_GTN_ATTRS_B GA
1207: WHERE UE.EVENT_ROW_ID =
1208: (
1209: SELECT

Line 1211: FROM EGO_UCCNET_EVENTS

1207: WHERE UE.EVENT_ROW_ID =
1208: (
1209: SELECT
1210: max(EVENT_ROW_ID)
1211: FROM EGO_UCCNET_EVENTS
1212: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1213: AND ORGANIZATION_ID = p_org_id
1214: AND EVENT_TYPE = 'REGISTRATION'
1215: AND EVENT_ACTION IN ('ADD', 'CHANGE', 'CORRECT')

Line 1222: FROM EGO_UCCNET_EVENTS

1218: AND NOT EXISTS
1219: (
1220: SELECT
1221: 1
1222: FROM EGO_UCCNET_EVENTS
1223: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1224: AND ORGANIZATION_ID = p_org_id
1225: AND EVENT_TYPE = 'REGISTRATION'
1226: AND DISPOSITION_CODE IS NULL

Line 1257: SELECT 1 FROM EGO_UCCNET_EVENTS

1253:
1254: SELECT 'Y' into l_temp
1255: FROM DUAL
1256: WHERE EXISTS(
1257: SELECT 1 FROM EGO_UCCNET_EVENTS
1258: WHERE inventory_item_id = p_inventory_item_id
1259: AND organization_id = p_org_id
1260: AND event_type = 'PUBLICATION'
1261: AND event_action IN ('NEW_ITEM', 'INITIAL_LOAD', 'DATA_CHANGE', 'CORRECTION')

Line 1597: FROM EGO_UCCNET_EVENTS

1593: l_ext_seq_val NUMBER;
1594:
1595: CURSOR c_customers IS
1596: SELECT PARTY_SITE_ID
1597: FROM EGO_UCCNET_EVENTS
1598: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1599: AND ORGANIZATION_ID = p_organization_id
1600: AND EVENT_TYPE = 'PUBLICATION'
1601: AND EVENT_ACTION IN ( 'INITIAL_LOAD', 'DATA_CHANGE', 'CORRECTION', 'NEW_ITEM' )

Line 3532: FROM EGO_UCCNET_EVENTS EV1

3528: WHERE NOT EXISTS
3529: (
3530: SELECT
3531: 1
3532: FROM EGO_UCCNET_EVENTS EV1
3533: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3534: AND ORGANIZATION_ID = p_org_id
3535: AND ADDRESS_ID = p_address_id
3536: AND EVENT_TYPE = 'PUBLICATION'

Line 3559: FROM EGO_UCCNET_EVENTS

3555: AND NOT EXISTS
3556: (
3557: SELECT
3558: 1
3559: FROM EGO_UCCNET_EVENTS
3560: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3561: AND ORGANIZATION_ID = p_org_id
3562: AND ADDRESS_ID = p_address_id
3563: AND EVENT_TYPE = 'PUBLICATION'

Line 3585: FROM EGO_UCCNET_EVENTS

3581: AND TP_NEUTRAL_UPDATE_DATE >
3582: (
3583: SELECT
3584: MAX(CREATION_DATE)
3585: FROM EGO_UCCNET_EVENTS
3586: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3587: AND ORGANIZATION_ID = p_org_id
3588: AND ADDRESS_ID = p_address_id
3589: AND EVENT_TYPE = 'PUBLICATION'