DBA Data[Home] [Help]

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 525: FROM ps_schd_hdr

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

Line 540: FROM ps_schd_hdr

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