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.BOM_ROLLUP_PUB dependencies on EGO_ITEM_GTN_ATTRS_B

Line 278: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

274: , p_Attribute_Value => NULL
275: , p_Attribute_Type => 'NUMBER'
276: , p_Compute_Function => 'Bom_Compute_Functions.Compute_Gross_Weight'
277: , p_Object_Name => 'EGO_ITEM'
278: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
279: );
280:
281: Add_Attribute_Map_Entry
282: ( p_Attribute_Name => 'COMPONENT_QUANTITY'

Line 296: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

292: , p_Attribute_Value => NULL
293: , p_Attribute_Type => 'VARCHAR2'
294: , p_Compute_Function => NULL
295: , p_Object_Name => 'EGO_ITEM'
296: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
297: );
298:
299: Add_Attribute_Map_Entry
300: ( p_Attribute_Name => 'BRAND_OWNER_NAME'

Line 305: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

301: , p_Attribute_Value => NULL
302: , p_Attribute_Type => 'VARCHAR2'
303: , p_Compute_Function => NULL
304: , p_Object_Name => 'EGO_ITEM'
305: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
306: );
307: Add_Attribute_Map_Entry
308: ( p_Attribute_Name => 'BRAND_OWNER_GLN'
309: , p_Attribute_Value => NULL

Line 313: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

309: , p_Attribute_Value => NULL
310: , p_Attribute_Type => 'VARCHAR2'
311: , p_Compute_Function => NULL
312: , p_Object_Name => 'EGO_ITEM'
313: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
314: );
315: Add_Attribute_Map_Entry
316: ( p_Attribute_Name => 'FUNCTIONAL_NAME'
317: , p_Attribute_Value => NULL

Line 329: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

325: , p_Attribute_Value => NULL
326: , p_Attribute_Type => 'VARCHAR2'
327: , p_Compute_Function => NULL
328: , p_Object_Name => 'EGO_ITEM'
329: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
330: );
331:
332: Add_Attribute_Map_Entry
333: ( p_Attribute_Name => 'CUSTOMER_ORDER_ENABLED_FLAG'

Line 347: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

343: , p_Attribute_Value => NULL
344: , p_Attribute_Type => 'VARCHAR2'
345: , p_Compute_Function => NULL
346: , p_Object_Name => 'EGO_ITEM'
347: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
348: );
349:
350: Add_Attribute_Map_Entry
351: ( p_Attribute_Name => 'PARENT_CUST_ORD_ENABLED_FLAG'

Line 383: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

379: , p_Attribute_Value => NULL
380: , p_Attribute_Type => 'VARCHAR2'
381: , p_Compute_Function => NULL
382: , p_Object_Name => 'EGO_ITEM'
383: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
384: );
385:
386: Add_Attribute_Map_Entry
387: ( p_Attribute_Name => 'SUB_BRAND'

Line 392: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

388: , p_Attribute_Value => NULL
389: , p_Attribute_Type => 'VARCHAR2'
390: , p_Compute_Function => NULL
391: , p_Object_Name => 'EGO_ITEM'
392: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
393: );
394:
395: Add_Attribute_Map_Entry
396: ( p_Attribute_Name => 'STORAGE_HANDLING_TEMP_MIN'

Line 401: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

397: , p_Attribute_Value => NULL
398: , p_Attribute_Type => 'NUMBER'
399: , p_Compute_Function => NULL
400: , p_Object_Name => 'EGO_ITEM'
401: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
402: );
403:
404: Add_Attribute_Map_Entry
405: ( p_Attribute_Name => 'UOM_STORAGE_HANDLING_TEMP_MIN'

Line 410: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

406: , p_Attribute_Value => NULL
407: , p_Attribute_Type => 'VARCHAR2'
408: , p_Compute_Function => NULL
409: , p_Object_Name => 'EGO_ITEM'
410: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
411: );
412:
413: Add_Attribute_Map_Entry
414: ( p_Attribute_Name => 'STORAGE_HANDLING_TEMP_MAX'

Line 419: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

415: , p_Attribute_Value => NULL
416: , p_Attribute_Type => 'NUMBER'
417: , p_Compute_Function => NULL
418: , p_Object_Name => 'EGO_ITEM'
419: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
420: );
421:
422: Add_Attribute_Map_Entry
423: ( p_Attribute_Name => 'UOM_STORAGE_HANDLING_TEMP_MAX'

Line 428: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'

424: , p_Attribute_Value => NULL
425: , p_Attribute_Type => 'VARCHAR2'
426: , p_Compute_Function => NULL
427: , p_Object_Name => 'EGO_ITEM'
428: , p_Attribute_Table_Name => 'EGO_ITEM_GTN_ATTRS_B'
429: );
430:
431: END Load_Attribute_Map;
432:

Line 708: ego_item_gtn_attrs_b gtn_attrs,

704: FROM mtl_system_items MTL2,
705: bom_inventory_components COM,
706: mtl_system_items MTL1,
707: bom_bill_of_materials BOM,
708: ego_item_gtn_attrs_b gtn_attrs,
709: ego_item_gtn_attrs_tl gtn_attrs_tl,
710: ego_item_gtn_attrs_b gtn_attrs_parent
711: WHERE
712: NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'XXXXXXXXXXX') =

Line 710: ego_item_gtn_attrs_b gtn_attrs_parent

706: mtl_system_items MTL1,
707: bom_bill_of_materials BOM,
708: ego_item_gtn_attrs_b gtn_attrs,
709: ego_item_gtn_attrs_tl gtn_attrs_tl,
710: ego_item_gtn_attrs_b gtn_attrs_parent
711: WHERE
712: NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'XXXXXXXXXXX') =
713: NVL(p_alternate_bom_code,'XXXXXXXXXXX')
714: AND COM.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID

Line 772: FROM ego_item_gtn_attrs_b

768: NOWAIT;
769:
770: CURSOR row_exist_gtin_attrs IS
771: SELECT inventory_item_id
772: FROM ego_item_gtn_attrs_b
773: WHERE inventory_item_id = p_item_id
774: AND organization_id = p_organization_id;
775:
776: CURSOR get_gdsn_enabled IS