APPS.GMPMRACT dependencies on PS_WHSE_EFF

Line 741: | Modified code to look for PS_WHSE_EFF |

737: | |
738: | MODIFICATION HISTORY |
739: | 01/01/03 Sridhar Gidugu ----- created |
740: | 12/19/03 Kalyani Manda Bug3168907 |
741: | Modified code to look for PS_WHSE_EFF |
742: | for item/whse_item_id combination for |
743: | considering the material activity |
744:
745: +============================================================================*/

Line 792: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id

788: CLOSE Cur_get_whse_item_id;
789:
790: /* Define Cursor per whse security to select the whse code */
791: IF nvl(G_whse_security,'N') = 'N' THEN
792: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
793: OPEN Cur_matl_act for
794: SELECT distinct trn.whse_code, whs.whse_item_id
795: FROM mr_tran_tbl trn, ps_schd_dtl sch, ps_whse_eff whs
796: WHERE sch.schedule_id = G_schedule_id

Line 795: FROM mr_tran_tbl trn, ps_schd_dtl sch, ps_whse_eff whs

791: IF nvl(G_whse_security,'N') = 'N' THEN
792: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
793: OPEN Cur_matl_act for
794: SELECT distinct trn.whse_code, whs.whse_item_id
795: FROM mr_tran_tbl trn, ps_schd_dtl sch, ps_whse_eff whs
796: WHERE sch.schedule_id = G_schedule_id
797: AND trn.mrp_id = G_mrp_id
798: AND item_id = V_item_id
799: AND whs.whse_code = trn.whse_code

Line 808: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id

804: OR X_twhse_code IS NULL)
805: ORDER BY 1;
806:
807: ELSE
808: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
809: OPEN Cur_matl_act for
810: SELECT distinct trn.whse_code, whs.whse_item_id
811: FROM mr_tran_tbl trn, ps_schd_dtl sch, sy_orgn_usr org, ps_whse_eff whs
812: WHERE sch.orgn_code = org.orgn_code

Line 811: FROM mr_tran_tbl trn, ps_schd_dtl sch, sy_orgn_usr org, ps_whse_eff whs

807: ELSE
808: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
809: OPEN Cur_matl_act for
810: SELECT distinct trn.whse_code, whs.whse_item_id
811: FROM mr_tran_tbl trn, ps_schd_dtl sch, sy_orgn_usr org, ps_whse_eff whs
812: WHERE sch.orgn_code = org.orgn_code
813: and sch.schedule_id = G_schedule_id
814: and mrp_id = G_mrp_id
815: and item_id = V_item_id