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 383: EGO_ATTRS_V AV,

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

Line 432: EGO_ATTRS_V AV,

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

Line 477: EGO_ATTRS_V AV,

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

Line 557: EGO_ATTRS_V AV,

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

Line 608: EGO_ATTRS_V AV,

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

Line 654: EGO_ATTRS_V AV,

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