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.GMD_SPREAD_FETCH_PKG dependencies on GMD_TECHNICAL_DATA_VL

Line 510: from gmd_technical_data_vl group by inventory_item_id,lot_number,lot_organization_id) c

506:
507: CURSOR Cur_get_materials IS
508: SELECT a.*, b.lot_number lot,b.expiration_date expire, b.inventory_item_id itemid
509: FROM gmd_material_details_gtmp a, mtl_lot_numbers b, (select inventory_item_id,lot_number, lot_organization_id
510: from gmd_technical_data_vl group by inventory_item_id,lot_number,lot_organization_id) c
511: WHERE a.entity_id = V_formula_id
512: AND a.inventory_item_id = b.inventory_item_id
513: AND a.inventory_item_id = c.inventory_item_id
514: AND b.organization_id = c.lot_organization_id

Line 1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1097: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1098: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1099: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1100: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1101: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1102: WHERE a.tech_parm_id = b.tech_parm_id
1103: AND a.organization_id = V_orgn_id
1104: AND a.inventory_item_id = c.inventory_item_id
1105: AND c.parent_line_id = V_matl_detl_id

Line 1110: FROM GMD_TECHNICAL_DATA_VL e

1106: AND c.entity_id = V_entity_id
1107: AND (V_line_id IS NULL OR c.line_id = V_line_id)
1108: AND (a.batch_id = V_entity_id OR
1109: (a.batch_id IS NULL AND NOT EXISTS ( SELECT 1
1110: FROM GMD_TECHNICAL_DATA_VL e
1111: WHERE e.inventory_item_id = c.inventory_item_id
1112: AND nvl(e.lot_number, '-1') = nvl(c.lot_number, '-1')
1113: AND nvl(e.lot_organization_id, c.organization_id) = c.organization_id
1114: AND e.formula_id IS NULL

Line 1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1160: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1161: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1162: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1163: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1164: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1165: WHERE a.tech_parm_id = b.tech_parm_id
1166: AND a.organization_id = V_orgn_id
1167: AND a.inventory_item_id = c.inventory_item_id
1168: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1173: FROM GMD_TECHNICAL_DATA_VL e

1169: AND c.entity_id = V_entity_id
1170: AND (V_line_id IS NULL OR c.line_id = V_line_id)
1171: AND (a.formula_id = c.tpformula_id OR
1172: (a.formula_id IS NULL AND NOT EXISTS (SELECT 1
1173: FROM GMD_TECHNICAL_DATA_VL e
1174: WHERE e.inventory_item_id = c.inventory_item_id
1175: AND NVL(e.lot_number, '-1') = NVL(c.lot_number, '-1')
1176: AND NVL(e.lot_organization_id, c.organization_id) = c.organization_id
1177: AND e.batch_id IS NULL

Line 1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1788: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1789: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1790: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1791: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1792: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1793: WHERE a.tech_parm_id = b.tech_parm_id
1794: AND a.organization_id = V_orgn_id
1795: AND a.inventory_item_id = c.inventory_item_id
1796: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)