DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on EGO_ATTRS_V

Line 287: EGO_ATTRS_V A

283: A.DATA_TYPE_CODE,
284: A.UOM_CLASS
285: FROM
286: EGO_ATTR_GROUPS_DL_V AG ,
287: EGO_ATTRS_V A
288: WHERE A.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE
289: AND A.ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
290: AND A.ATTR_GROUP_NAME = AG.ATTR_GROUP_NAME
291: AND A.APPLICATION_ID = AG.APPLICATION_ID

Line 382: EGO_ATTRS_V AV,

378: AV.DATA_TYPE_CODE,
379: AV.UOM_CLASS
380: FROM
381: EGO_ITM_USR_ATTR_INTRFC I,
382: EGO_ATTRS_V AV,
383: EGO_ATTR_GROUPS_DL_V AGV
384: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
385: AND AV.ATTR_NAME = I.ATTR_INT_NAME
386: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME

Line 431: EGO_ATTRS_V AV,

427: AV.VALIDATION_CODE,
428: AV.DATA_TYPE_CODE
429: FROM
430: EGO_ITM_USR_ATTR_INTRFC I,
431: EGO_ATTRS_V AV,
432: EGO_ATTR_GROUPS_DL_V AGV
433: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
434: AND AV.ATTR_NAME = I.ATTR_INT_NAME
435: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME

Line 476: EGO_ATTRS_V AV,

472: AV.DATA_TYPE_CODE,
473: AV.UOM_CLASS
474: FROM
475: EGO_ITM_USR_ATTR_INTRFC I,
476: EGO_ATTRS_V AV,
477: EGO_ATTR_GROUPS_DL_V AGV
478: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
479: AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
480: AND AV.ATTR_NAME = I.ATTR_INT_NAME

Line 556: EGO_ATTRS_V AV,

552: AV.DATA_TYPE_CODE,
553: AV.UOM_CLASS
554: FROM
555: EGO_ITM_USR_ATTR_INTRFC I,
556: EGO_ATTRS_V AV,
557: EGO_ATTR_GROUPS_DL_V AGV
558: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
559: AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
560: OR

Line 607: EGO_ATTRS_V AV,

603: AV.DATA_TYPE_CODE,
604: AV.UOM_CLASS
605: FROM
606: EGO_ITM_USR_ATTR_INTRFC I,
607: EGO_ATTRS_V AV,
608: EGO_ATTR_GROUPS_DL_V AGV
609: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
610: AND AV.ATTR_NAME = I.ATTR_INT_NAME
611: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME

Line 653: EGO_ATTRS_V AV,

649: AV.DATA_TYPE_CODE,
650: AV.UOM_CLASS
651: FROM
652: EGO_ITM_USR_ATTR_INTRFC I,
653: EGO_ATTRS_V AV,
654: EGO_ATTR_GROUPS_DL_V AGV
655: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
656: AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
657: AND AV.ATTR_NAME = I.ATTR_INT_NAME