APPS.PKG_GMP_BUCKET_DATA dependencies on PS_SCHD_HDR

Line 42: FROM ps_schd_hdr

38: AND INSTR(V_whse_list, whse_code) <> 0
39: ORDER BY trans_date asc, trans_qty desc;
40: CURSOR Cur_schedule IS
41: SELECT no_days, no_weeks, no_4weeks, no_13weeks
42: FROM ps_schd_hdr
43: WHERE schedule_id = V_schedule
44: AND delete_mark = 0;
45: CURSOR Cur_check_hdr IS
46: SELECT matl_rep_id

Line 523: FROM ps_schd_hdr

519:
520: /* 29-Jan-04 - B3394924 - Sowmya - SALES ORDERS BEING SEEN ON MPS INQUIRY SCREEN EVEN WHEN EXCLUDED IN SCHEDULE */
521: CURSOR Get_ord_ind_cur IS
522: SELECT order_ind
523: FROM ps_schd_hdr
524: WHERE schedule_id = V_schedule;
525: /* akaruppa changed the cursor to obtain the UOM from MTL_SYSTEM_ITEMS
526: CURSOR Cur_item_um IS
527: SELECT item_um, item_um2

Line 538: FROM ps_schd_hdr

534: WHERE inventory_item_id = V_item_id;
535:
536: CURSOR Cur_schedule IS
537: SELECT no_days, no_weeks, no_4weeks, no_13weeks
538: FROM ps_schd_hdr
539: WHERE schedule_id = V_schedule
540: AND delete_mark = 0;
541: CURSOR Cur_check_hdr IS
542: SELECT matl_rep_id