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_ITEM_GTN_ATTRS_B

Line 526: FROM EGO_ITEM_GTN_ATTRS_B EGA2,

522: AND UE.CREATION_DATE >=
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

Line 675: FROM EGO_ITEM_GTN_ATTRS_B EGA2,

671: OR UE.CREATION_DATE <
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

Line 1146: EGO_ITEM_GTN_ATTRS_B GA

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
1150: max(EVENT_ROW_ID)

Line 1206: EGO_ITEM_GTN_ATTRS_B GA

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
1210: max(EVENT_ROW_ID)

Line 1310: UPDATE EGO_ITEM_GTN_ATTRS_B

1306: */
1307: PROCEDURE PROCESS_CAT_ASSIGNMENT ( p_inventory_item_id NUMBER,
1308: p_organization_id NUMBER) AS
1309: BEGIN
1310: UPDATE EGO_ITEM_GTN_ATTRS_B
1311: SET REGISTRATION_UPDATE_DATE = SYSDATE
1312: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1313: AND ORGANIZATION_ID = p_organization_id;
1314: EXCEPTION

Line 1448: UPDATE EGO_ITEM_GTN_ATTRS_B

1444: END IF;
1445: END LOOP; -- i
1446:
1447: IF l_reg_attr_updated = TRUE THEN
1448: UPDATE EGO_ITEM_GTN_ATTRS_B
1449: SET REGISTRATION_UPDATE_DATE = SYSDATE,
1450: TP_NEUTRAL_UPDATE_DATE = SYSDATE
1451: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1452: AND ORGANIZATION_ID = p_organization_id;

Line 1455: UPDATE EGO_ITEM_GTN_ATTRS_B

1451: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1452: AND ORGANIZATION_ID = p_organization_id;
1453: ELSE
1454: IF p_attribute_names.COUNT > 0 AND l_non_tp_attr_updated THEN
1455: UPDATE EGO_ITEM_GTN_ATTRS_B
1456: SET TP_NEUTRAL_UPDATE_DATE = SYSDATE
1457: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1458: AND ORGANIZATION_ID = p_organization_id;
1459: ELSIF p_attribute_names.COUNT > 0 AND (l_tp_attr_updated AND (NOT l_non_tp_attr_updated) ) THEN

Line 1622: UPDATE EGO_ITEM_GTN_ATTRS_B

1618: EXCEPTION WHEN NO_DATA_FOUND THEN
1619: write_debug_log('Attribute group does not belongs to EGO_ITEM_TP_EXT_ATTRS, so updating TP_NEUTRAL_UPDATE_DATE');
1620: -- even if a single attribute other than TP-Dependant attribute is updated, update the TP-Neutral Update date.
1621: FOR i IN p_attribute_names.FIRST..p_attribute_names.LAST LOOP
1622: UPDATE EGO_ITEM_GTN_ATTRS_B
1623: SET TP_NEUTRAL_UPDATE_DATE = SYSDATE
1624: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1625: AND ORGANIZATION_ID = p_organization_id;
1626:

Line 2138: UPDATE EGO_ITEM_GTN_ATTRS_B

2134: x_msg_data OUT NOCOPY VARCHAR2)
2135: IS
2136: BEGIN
2137: IF NVL(p_update_reg, 'N') = 'Y' THEN
2138: UPDATE EGO_ITEM_GTN_ATTRS_B
2139: SET REGISTRATION_UPDATE_DATE = SYSDATE,
2140: TP_NEUTRAL_UPDATE_DATE = SYSDATE
2141: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2142: AND ORGANIZATION_ID = p_organization_id;

Line 2144: UPDATE EGO_ITEM_GTN_ATTRS_B

2140: TP_NEUTRAL_UPDATE_DATE = SYSDATE
2141: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2142: AND ORGANIZATION_ID = p_organization_id;
2143: ELSE
2144: UPDATE EGO_ITEM_GTN_ATTRS_B
2145: SET TP_NEUTRAL_UPDATE_DATE = SYSDATE
2146: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2147: AND ORGANIZATION_ID = p_organization_id;
2148: END IF;

Line 2844: l_gtin_dml_str := 'UPDATE ego_item_gtn_attrs_b SET ';

2840: BEGIN
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: -- for now just update
2844: l_gtin_dml_str := 'UPDATE ego_item_gtn_attrs_b SET ';
2845: l_gtin_dml_str := l_gtin_dml_str || 'TOP_GTIN = ''' || p_top_gtin_flag || '''';
2846: l_gtin_dml_str := l_gtin_dml_str ||
2847: ' WHERE inventory_item_id = :item_id ' ||
2848: ' AND organization_id = :org_id ' ;

Line 3575: FROM EGO_ITEM_GTN_ATTRS_B EGA,

3571: AND EXISTS
3572: (
3573: SELECT
3574: 1
3575: FROM EGO_ITEM_GTN_ATTRS_B EGA,
3576: BOM_EXPLOSIONS_ALL_V EXPL
3577: WHERE EXPL.GROUP_ID = p_explode_group_id
3578: AND EXPL.TOP_ITEM_ID = p_inventory_item_id
3579: AND EXPL.ORGANIZATION_ID = EGA.ORGANIZATION_ID

Line 3917: ' FROM EGO_SBDH_TRADE_ITEM_INFO_AGV sbdh, EGO_ITEM_GTN_ATTRS_B core ' ||

3913:
3914: -- 5. pegHorizontal, pegVertical and pegHoleNumber should be specified when either of them is specified.
3915: BEGIN
3916: l_sql := ' SELECT sbdh.PEG_HOLE_NUMBER, core.PEG_VERTICAL, core.PEG_HORIZONTAL ' ||
3917: ' FROM EGO_SBDH_TRADE_ITEM_INFO_AGV sbdh, EGO_ITEM_GTN_ATTRS_B core ' ||
3918: ' WHERE core.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
3919: ' AND core.ORGANIZATION_ID = :p_organization_id ' ||
3920: ' AND sbdh.INVENTORY_ITEM_ID (+) = core.INVENTORY_ITEM_ID ' ||
3921: ' AND sbdh.ORGANIZATION_ID (+) = core.ORGANIZATION_ID ';

Line 4713: ' FROM EGO_SBDH_TRADE_ITEM_INFO_AGV sbdh, EGO_ITEM_GTN_ATTRS_B core ' ||

4709:
4710: -- 5. pegHorizontal, pegVertical and pegHoleNumber should be specified when either of them is specified.
4711: BEGIN
4712: l_sql := ' SELECT sbdh.PEG_HOLE_NUMBER, core.PEG_VERTICAL, core.PEG_HORIZONTAL ' ||
4713: ' FROM EGO_SBDH_TRADE_ITEM_INFO_AGV sbdh, EGO_ITEM_GTN_ATTRS_B core ' ||
4714: ' WHERE core.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
4715: ' AND core.ORGANIZATION_ID = :p_organization_id ' ||
4716: ' AND sbdh.INVENTORY_ITEM_ID (+) = core.INVENTORY_ITEM_ID ' ||
4717: ' AND sbdh.ORGANIZATION_ID (+) = core.ORGANIZATION_ID ';

Line 5085: l_b_sql := 'UPDATE EGO_ITEM_GTN_ATTRS_B SET ';

5081: SAVEPOINT GTID_UPDATE;
5082: WRITE_DEBUG_LOG('Starting PROCESS_GTID_UPDATE');
5083: WRITE_DEBUG_LOG('Parameters: p_inventory_item_id, p_organization_id, p_trade_item_desc=' || p_inventory_item_id ||','|| p_organization_id||','|| p_trade_item_desc);
5084: IF NVL(p_trade_item_desc, 'BASE_UNIT_OR_EACH') <> 'BASE_UNIT_OR_EACH' THEN
5085: l_b_sql := 'UPDATE EGO_ITEM_GTN_ATTRS_B SET ';
5086: l_tl_sql := 'UPDATE EGO_ITEM_GTN_ATTRS_TL SET ';
5087: l_execute_b_sql := FALSE;
5088: l_execute_tl_sql := FALSE;
5089: FOR i IN c_single_attrs_not_upd LOOP