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 1134: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1130: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1131: SELECT V_entity_id,c.line_id,a.tech_parm_name, a.tech_parm_id,
1132: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1133: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1134: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1135: WHERE a.tech_parm_id = b.tech_parm_id
1136: AND a.organization_id = V_orgn_id
1137: AND a.inventory_item_id = c.inventory_item_id
1138: AND (V_matl_detl_id IS NULL OR c.parent_line_id = V_matl_detl_id)

Line 1143: FROM GMD_TECHNICAL_DATA_VL e

1139: AND c.entity_id = V_entity_id
1140: AND (V_line_id IS NULL OR c.line_id = V_line_id)
1141: AND (a.batch_id = V_entity_id OR
1142: (a.batch_id IS NULL AND NOT EXISTS ( SELECT 1
1143: FROM GMD_TECHNICAL_DATA_VL e
1144: WHERE e.inventory_item_id = c.inventory_item_id
1145: AND nvl(e.lot_number, '-1') = nvl(c.lot_number, '-1')
1146: AND nvl(e.lot_organization_id, c.organization_id) = c.organization_id
1147: AND e.formula_id IS NULL

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

1193: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1194: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
1195: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1196: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1197: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1198: WHERE a.tech_parm_id = b.tech_parm_id
1199: AND a.organization_id = V_orgn_id
1200: AND a.inventory_item_id = c.inventory_item_id
1201: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1206: FROM GMD_TECHNICAL_DATA_VL e

1202: AND c.entity_id = V_entity_id
1203: AND (V_line_id IS NULL OR c.line_id = V_line_id)
1204: AND (a.formula_id = c.tpformula_id OR
1205: (a.formula_id IS NULL AND NOT EXISTS (SELECT 1
1206: FROM GMD_TECHNICAL_DATA_VL e
1207: WHERE e.inventory_item_id = c.inventory_item_id
1208: AND NVL(e.lot_number, '-1') = NVL(c.lot_number, '-1')
1209: AND NVL(e.lot_organization_id, c.organization_id) = c.organization_id
1210: AND e.batch_id IS NULL

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

1835: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
1836: SELECT V_entity_id,c.line_id,b.tech_parm_name,a.tech_parm_id,
1837: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
1838: b.sort_seq,a.num_data,a.text_data,a.boolean_data
1839: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1840: WHERE a.tech_parm_id = b.tech_parm_id
1841: AND a.organization_id = V_orgn_id
1842: AND a.inventory_item_id = c.inventory_item_id
1843: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 1948: FROM gmd_material_details_gtmp a, ic_lots_mst b, (select item_id,lot_id from gmd_technical_data_vl group by item_id,lot_id) c

1944:
1945:
1946: /* CURSOR Cur_get_materials IS
1947: SELECT a.*,b.lot_no lot, b.sublot_no sublot, b.lot_id item_lotid, b.expire_date expire, b.item_id itemid
1948: FROM gmd_material_details_gtmp a, ic_lots_mst b, (select item_id,lot_id from gmd_technical_data_vl group by item_id,lot_id) c
1949: WHERE a.entity_id = V_formula_id
1950: AND a.item_id = b.item_id
1951: AND a.item_id = c.item_id
1952: AND b.lot_id = c.lot_id

Line 1962: (select inventory_item_id,lot_NUMBER from gmd_technical_data_vl group by inventory_item_id,lot_NUMBER) c

1958:
1959: CURSOR Cur_get_materials IS
1960: SELECT a.*,b.PARENT_LOT_NUMBER lot, b.LOT_NUMBER sublot, NULL item_lotid, b.EXPIRATION_DATE expire, b.inventory_item_id itemid
1961: FROM gmd_material_details_gtmp a, MTL_LOT_NUMBERS b,
1962: (select inventory_item_id,lot_NUMBER from gmd_technical_data_vl group by inventory_item_id,lot_NUMBER) c
1963: WHERE a.entity_id = V_formula_id
1964: AND a.inventory_item_id = b.inventory_item_id
1965: AND a.inventory_item_id = c.inventory_item_id
1966: and b.organization_id = V_orgn_id

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

2109: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2110: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2111: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2112: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2113: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2114: WHERE a.tech_parm_id = b.tech_parm_id
2115: AND a.organization_id = V_orgn_id
2116: AND a.item_id = c.item_id
2117: AND (V_formulaline_id IS NULL OR c.parent_line_id = V_formulaline_id)

Line 2122: FROM GMD_TECHNICAL_DATA_VL e

2118: AND c.entity_id = V_entity_id
2119: AND (V_line_id IS NULL OR c.line_id = V_line_id)
2120: AND (a.formula_id = c.tpformula_id OR
2121: (a.formula_id IS NULL AND NOT EXISTS ( SELECT 1
2122: FROM GMD_TECHNICAL_DATA_VL e
2123: WHERE e.item_id = c.item_id
2124: AND nvl(e.lot_id, -1) = nvl(c.lot_id, -1)
2125: AND e.batch_id IS NULL
2126: AND e.formula_id = c.tpformula_id

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

2133: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2134: SELECT V_entity_id,c.line_id,a.tech_parm_name,a.tech_parm_id,
2135: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2136: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2137: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
2138: WHERE a.tech_parm_id = b.tech_parm_id
2139: AND a.organization_id = V_orgn_id
2140: AND a.inventory_item_id = c.inventory_item_id
2141: and c.organization_id = V_orgn_id

Line 2147: FROM GMD_TECHNICAL_DATA_VL e

2143: AND c.entity_id = V_entity_id
2144: AND (V_line_id IS NULL OR c.line_id = V_line_id)
2145: AND (a.formula_id = c.tpformula_id OR
2146: (a.formula_id IS NULL AND NOT EXISTS ( SELECT 1
2147: FROM GMD_TECHNICAL_DATA_VL e
2148: WHERE e.inventory_item_id = c.inventory_item_id
2149: AND nvl(e.lot_id, -1) = nvl(c.lot_id, -1)
2150: AND e.batch_id IS NULL
2151: AND e.formula_id = c.tpformula_id

Line 2168: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b--, gmd_material_details_gtmp c

2164: VALUE,SORT_SEQ,NUM_DATA,TEXT_DATA,BOOLEAN_DATA)
2165: SELECT V_entity_id,V_line_id,a.tech_parm_name,a.tech_parm_id,
2166: DECODE(B.DATA_TYPE,0,TEXT_DATA,2,TEXT_DATA,3,BOOLEAN_DATA,NUM_DATA) VALUE,
2167: b.sort_seq,a.num_data,a.text_data,a.boolean_data
2168: FROM gmd_technical_data_vl a, gmd_technical_parameter_gtmp b--, gmd_material_details_gtmp c
2169: WHERE a.tech_parm_id = b.tech_parm_id
2170: AND a.organization_id = V_orgn_id ---1
2171: AND a.inventory_item_id = V_item_id
2172: AND a.formula_id is null