APPS.GMD_COA_DATA_OM dependencies on IC_WHSE_MST

Line 968: /*CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS

964: AND S.SITE_USE_ID = c_ship_to_org_id
965: ;*/
966:
967:
968: /*CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS
969: SELECT whse_name
970: FROM
971: ic_whse_mst
972: WHERE

Line 971: ic_whse_mst

967:
968: /*CURSOR get_whse_info (c_whse_code ic_whse_mst.WHSE_CODE%TYPE) IS
969: SELECT whse_name
970: FROM
971: ic_whse_mst
972: WHERE
973: whse_code = c_whse_code
974: and delete_mark = 0
975: ;*/

Line 981: ic_whse_mst w,

977: SELECT s.orgn_code,
978: w.whse_code,
979: w.whse_name
980: FROM mtl_parameters p,
981: ic_whse_mst w,
982: sy_orgn_mst s
983: WHERE
984: w.mtl_organization_id = c_ship_from_org_id
985: AND p.ORGANIZATION_ID = c_ship_from_org_id

Line 1112: /* end getting warehouse info from ic_whse_mst */

1108: tbl_hdr(tbl_ndx).whse_code := whse_cur_rec.whse_code;
1109: tbl_hdr(tbl_ndx).whse_name := whse_cur_rec.whse_name;
1110: tbl_hdr(tbl_ndx).orgn_code := whse_cur_rec.orgn_code;
1111: END LOOP;
1112: /* end getting warehouse info from ic_whse_mst */
1113: END IF;
1114:
1115:
1116: