APPS.MSC_CL_GMP_UTILITY dependencies on IC_ITEM_MST

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

745: /* SGIDUGU - Seq Dep */
746: or_setup_id number_idx_tbl ;
747: gt_setup_id number_idx_tbl ;
748: --
749: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY
750: BINARY_INTEGER;
751: gt_seq_dep_class seq_dep_class_typ ;
752: empty_seq_dep_class seq_dep_class_typ ;
753: --

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

5702: REM| |
5703: REM| 15th July 1999 P.J.Schofield |
5704: REM| Include inventory_item_id from mtl_system_items and uom_code from |
5705: REM| mtl_units_of_measure |
5706: REM| 04/03/2000 - Using mtl_organization_id from ic_item_mst instead of |
5707: REM| - organization_id from sy_orgn_mst table. Bug# 1252322 |
5708: REM| 12/14/00 - B1540127 By Rajesh Patangya |
5709: REM| join change for unit_of_measure field in sy_uoms_mst |
5710: REM| 04/21/2004 - Navin Sinha - B3577871 -ST:OSFME2: collections failing |

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

5794: ||' pwe.plant_code, iim.creation_date, iim.created_by, '
5795: ||' iim.last_update_date,iim.last_updated_by, NULL '
5796: /* Bug # 5238790 */
5797: ||' ,NVL(iim.experimental_ind,0) '
5798: ||' FROM ic_item_mst'||at_apps_link||' iim,'
5799: ||' sy_uoms_mst'||at_apps_link||' sou,' /* B1540127 */
5800: ||' ps_whse_eff'||at_apps_link||' pwe,'
5801: ||' ic_whse_mst'||at_apps_link||' iwm,'
5802: ||' mtl_system_items'||at_apps_link||' msi,'

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

10527: || ' s.loct_onhand'
10528: || ' FROM'
10529: || ' ic_loct_inv'||pdblink||' s,'
10530: || ' ic_lots_mst'||pdblink||' l,'
10531: || ' ic_item_mst_b'||pdblink||' m,'
10532: || ' (select distinct aps_item_id,item_id,whse_code,organization_id, '
10533: || ' lot_control,experimental_ind from gmp_item_aps'||pdblink||') i'
10534: || ' WHERE'
10535: || ' s.item_id = i.item_id'

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

10630: || ' decode(t.order_proc_ind,0,s.loct_onhand,0)'
10631: || ' FROM'
10632: || ' ic_loct_inv'||pdblink||' s,'
10633: || ' ic_lots_mst'||pdblink||' l,'
10634: || ' ic_item_mst_b'||pdblink||' m,'
10635: || ' (select distinct aps_item_id, item_id, whse_code, organization_id, '
10636: || ' lot_control,experimental_ind from gmp_item_aps'||pdblink||') i,'
10637: || ' ic_lots_sts'||pdblink||' t,'
10638: || ' ic_lots_cpg'||pdblink||' c'

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

11377: || ' d.requested_shipdate, ' /* B2971996 */
11378: || ' (sum(t.trans_qty) * -1) trans_qty '
11379: || ' FROM '
11380: || ' mtl_system_items'||pdblink||' msi, '
11381: || ' ic_item_mst'||pdblink||' iim,'
11382: || ' ic_whse_mst'||pdblink||' wm, '
11383: || ' op_ordr_hdr'||pdblink||' h, '
11384: || ' op_ordr_dtl'||pdblink||' d, '
11385: || ' ic_tran_pnd'||pdblink||' t '

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

11469: || ' (sum(d.trans_qty * -1) ) consumed_qty ,'
11470: || ' 0 use_fcst_flag '
11471: || ' FROM '
11472: || ' mtl_system_items'||pdblink||' msi, '
11473: || ' ic_item_mst'||pdblink||' iim, '
11474: || ' ic_whse_mst'||pdblink||' wm, '
11475: || ' fc_fcst_hdr'||pdblink||' h, '
11476: || ' fc_fcst_dtl'||pdblink||' d '
11477: || ' WHERE '

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

12281: || ' (d.trans_qty * -1) trans_qty, '
12282: || ' 0 use_fcst_flag '
12283: || ' FROM '
12284: || ' mtl_system_items'||pdblink||' msi, '
12285: || ' ic_item_mst'||pdblink||' iim, '
12286: || ' ic_whse_mst'||pdblink||' wm, '
12287: || ' fc_fcst_hdr'||pdblink||' h, '
12288: || ' fc_fcst_dtl'||pdblink||' d '
12289: || ' WHERE '