APPS.MSC_CL_GMP_UTILITY dependencies on IC_ITEM_MST

Line 760: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY

756: -- Bug:6030499 end
757:
758:
759:
760: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY
761: BINARY_INTEGER;
762: gt_seq_dep_class seq_dep_class_typ ;
763: empty_seq_dep_class seq_dep_class_typ ;
764: --

Line 6111: REM| 04/03/2000 - Using mtl_organization_id from ic_item_mst instead of |

6107: REM| |
6108: REM| 15th July 1999 P.J.Schofield |
6109: REM| Include inventory_item_id from mtl_system_items and uom_code from |
6110: REM| mtl_units_of_measure |
6111: REM| 04/03/2000 - Using mtl_organization_id from ic_item_mst instead of |
6112: REM| - organization_id from sy_orgn_mst table. Bug# 1252322 |
6113: REM| 12/14/00 - B1540127 By Rajesh Patangya |
6114: REM| join change for unit_of_measure field in sy_uoms_mst |
6115: REM| 04/21/2004 - Navin Sinha - B3577871 -ST:OSFME2: collections failing |

Line 6259: ||' FROM ic_item_mst'||at_apps_link||' iim,'

6255: ||' decode(sum(pwe.consum_ind), 0, 0, 1), '
6256: ||' pwe.plant_code, :r_dt1, iim.created_by, '
6257: ||' :r_dt2,iim.last_updated_by, 0, '
6258: ||' NVL(iim.experimental_ind,0) ' /* Bug # 5238790 */
6259: ||' FROM ic_item_mst'||at_apps_link||' iim,'
6260: ||' sy_uoms_mst'||at_apps_link||' sou,' /* B1540127 */
6261: ||' ps_whse_eff'||at_apps_link||' pwe,'
6262: ||' ic_whse_mst'||at_apps_link||' iwm,'
6263: ||' mtl_system_items'||at_apps_link||' msi,'

Line 11189: || ' ic_item_mst_b'||pdblink||' m,'

11185: || ' s.loct_onhand'
11186: || ' FROM'
11187: || ' ic_loct_inv'||pdblink||' s,'
11188: || ' ic_lots_mst'||pdblink||' l,'
11189: || ' ic_item_mst_b'||pdblink||' m,'
11190: || ' (select distinct aps_item_id,item_id,whse_code,organization_id, '
11191: || ' lot_control,experimental_ind from gmp_item_aps'||pdblink||') i'
11192: || ' WHERE'
11193: || ' s.item_id = i.item_id'

Line 11310: || ' ic_item_mst_b'||pdblink||' m,'

11306: || ' decode(t.order_proc_ind,0,s.loct_onhand,0)'
11307: || ' FROM'
11308: || ' ic_loct_inv'||pdblink||' s,'
11309: || ' ic_lots_mst'||pdblink||' l,'
11310: || ' ic_item_mst_b'||pdblink||' m,'
11311: || ' (select distinct aps_item_id, item_id, whse_code, organization_id, '
11312: || ' lot_control,experimental_ind from gmp_item_aps'||pdblink||') i,'
11313: || ' ic_lots_sts'||pdblink||' t,'
11314: || ' ic_lots_cpg'||pdblink||' c'

Line 12131: || ' ic_item_mst'||pdblink||' iim,'

12127: || ' d.requested_shipdate, ' /* B2971996 */
12128: || ' (sum(t.trans_qty) * -1) trans_qty '
12129: || ' FROM '
12130: || ' mtl_system_items'||pdblink||' msi, '
12131: || ' ic_item_mst'||pdblink||' iim,'
12132: || ' ic_whse_mst'||pdblink||' wm, '
12133: || ' op_ordr_hdr'||pdblink||' h, '
12134: || ' op_ordr_dtl'||pdblink||' d, '
12135: || ' ic_tran_pnd'||pdblink||' t '

Line 12223: || ' ic_item_mst'||pdblink||' iim, '

12219: || ' (sum(d.trans_qty * -1) ) consumed_qty ,'
12220: || ' 0 use_fcst_flag '
12221: || ' FROM '
12222: || ' mtl_system_items'||pdblink||' msi, '
12223: || ' ic_item_mst'||pdblink||' iim, '
12224: || ' ic_whse_mst'||pdblink||' wm, '
12225: || ' fc_fcst_hdr'||pdblink||' h, '
12226: || ' fc_fcst_dtl'||pdblink||' d '
12227: || ' WHERE '

Line 13070: || ' ic_item_mst'||pdblink||' iim, '

13066: || ' (d.trans_qty * -1) trans_qty, '
13067: || ' 0 use_fcst_flag '
13068: || ' FROM '
13069: || ' mtl_system_items'||pdblink||' msi, '
13070: || ' ic_item_mst'||pdblink||' iim, '
13071: || ' ic_whse_mst'||pdblink||' wm, '
13072: || ' fc_fcst_hdr'||pdblink||' h, '
13073: || ' fc_fcst_dtl'||pdblink||' d '
13074: || ' WHERE '