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_CUST_ATTRS_B

Line 510: FROM EGO_ITEM_CUST_ATTRS_B EICA,

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

Line 659: FROM EGO_ITEM_CUST_ATTRS_B EICA,

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

Line 1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;

1373: x_error_message VARCHAR2(2000);
1374: l_rollup_reqd BOOLEAN := FALSE;
1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;
1376:
1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;

Line 1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;

1374: l_rollup_reqd BOOLEAN := FALSE;
1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;
1376:
1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;

Line 1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;

1375: l_gtin MTL_CROSS_REFERENCES.CROSS_REFERENCE%TYPE;
1376:
1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;

Line 1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;

1376:
1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;
1384:

Line 1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;

1377: l_start_availability_date_time EGO_ITEM_CUST_ATTRS_B.START_AVAILABILITY_DATE_TIME%TYPE;
1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;
1384:
1385: l_reg_attr_list EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(Net_Content, Uom_Net_Content, Trade_Item_Descriptor, Brand_Name,

Line 1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;

1378: l_end_availability_date_time EGO_ITEM_CUST_ATTRS_B.END_AVAILABILITY_DATE_TIME%TYPE;
1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;
1384:
1385: l_reg_attr_list EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(Net_Content, Uom_Net_Content, Trade_Item_Descriptor, Brand_Name,
1386: Is_Trade_Item_A_Consumer_Unit, Customer_Order_Enabled_Flag,

Line 1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;

1379: l_is_trade_item_a_despatch_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_A_DESPATCH_UNIT%TYPE;
1380: l_is_trade_item_an_invoice_unt EGO_ITEM_CUST_ATTRS_B.IS_TRADE_ITEM_AN_INVOICE_UNIT%TYPE;
1381: l_min_trade_item_life_arr EGO_ITEM_CUST_ATTRS_B.MIN_TRADE_ITEM_LIFE_ARR%TYPE;
1382: l_order_quantity_min EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MIN%TYPE;
1383: l_order_quantity_max EGO_ITEM_CUST_ATTRS_B.ORDER_QUANTITY_MAX%TYPE;
1384:
1385: l_reg_attr_list EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(Net_Content, Uom_Net_Content, Trade_Item_Descriptor, Brand_Name,
1386: Is_Trade_Item_A_Consumer_Unit, Customer_Order_Enabled_Flag,
1387: Unit_Weight, Unit_Height, Unit_Length, Unit_Width, Unit_Volume,

Line 1491: FROM EGO_ITEM_CUST_ATTRS_B

1487: l_is_trade_item_an_invoice_unt,
1488: l_min_trade_item_life_arr,
1489: l_order_quantity_min,
1490: l_order_quantity_max
1491: FROM EGO_ITEM_CUST_ATTRS_B
1492: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1493: AND MASTER_ORGANIZATION_ID = p_organization_id
1494: AND PARTY_SITE_ID = i.PARTY_SITE_ID;
1495:

Line 1517: UPDATE EGO_ITEM_CUST_ATTRS_B

1513: END IF;
1514: END LOOP; --FOR j IN p_attribute_names.FIRST..p_attribute_names.LAST LOOP
1515:
1516: IF l_update_last_upd_date THEN
1517: UPDATE EGO_ITEM_CUST_ATTRS_B
1518: SET LAST_UPDATE_DATE = SYSDATE
1519: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1520: AND MASTER_ORGANIZATION_ID = p_organization_id
1521: AND PARTY_SITE_ID = i.PARTY_SITE_ID;

Line 1524: INSERT INTO EGO_ITEM_CUST_ATTRS_B

1520: AND MASTER_ORGANIZATION_ID = p_organization_id
1521: AND PARTY_SITE_ID = i.PARTY_SITE_ID;
1522: END IF; --IF l_update_last_upd_date THEN
1523: EXCEPTION WHEN NO_DATA_FOUND THEN
1524: INSERT INTO EGO_ITEM_CUST_ATTRS_B
1525: (
1526: EXTENSION_ID,
1527: INVENTORY_ITEM_ID,
1528: MASTER_ORGANIZATION_ID,

Line 4436: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||

4432:
4433: -- 15. MIN_TRADE_ITEM_LIFE_ARR can not be more than MIN_TRADE_ITEM_LIFE_PROD
4434: BEGIN
4435: l_sql := ' SELECT NVL(C.MIN_TRADE_ITEM_LIFE_ARR, MSI.SHELF_LIFE_DAYS) MIN_TRADE_ITEM_LIFE_ARR ' ||
4436: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||
4437: ' WHERE C.PARTY_SITE_ID (+) = :party_site_id ' ||
4438: ' AND MSI.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
4439: ' AND MSI.ORGANIZATION_ID = :p_organization_id ' ||
4440: ' AND MSI.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID (+) '||

Line 4976: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||

4972:
4973: -- 15. MIN_TRADE_ITEM_LIFE_ARR can not be more than MIN_TRADE_ITEM_LIFE_PROD
4974: BEGIN
4975: l_sql := ' SELECT NVL(C.MIN_TRADE_ITEM_LIFE_ARR, MSI.SHELF_LIFE_DAYS) MIN_TRADE_ITEM_LIFE_ARR ' ||
4976: ' FROM MTL_SYSTEM_ITEMS_B MSI,EGO_ITEM_CUST_ATTRS_B C ' ||
4977: ' WHERE C.PARTY_SITE_ID (+) = :party_site_id ' ||
4978: ' AND MSI.INVENTORY_ITEM_ID = :p_inventory_item_id ' ||
4979: ' AND MSI.ORGANIZATION_ID = :p_organization_id ' ||
4980: ' AND MSI.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID (+) '||