APPS.WSH_PR_PICKING_SESSION dependencies on SO_PICKING_RULES

Line 646: FROM SO_PICKING_RULES

642: AND NVL(END_DATE_ACTIVE, SYSDATE+1);
643:
644: CURSOR pick_rule(x_rule_name IN VARCHAR2) IS
645: SELECT COUNT(*)
646: FROM SO_PICKING_RULES
647: WHERE PICKING_RULE = x_rule_name
648: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
649: AND NVL(END_DATE_ACTIVE, SYSDATE+1);
650:

Line 654: SO_PICKING_RULES rules

650:
651: CURSOR get_default_psr(x_rule_name IN VARCHAR2) IS
652: SELECT par.pick_slip_rule_id
653: FROM WSH_PARAMETERS par,
654: SO_PICKING_RULES rules
655: WHERE rules.picking_rule = x_rule_name
656: AND rules.warehouse_id = par.organization_id;
657:
658: CURSOR get_default_rsr(x_rule_name IN VARCHAR2) IS

Line 661: SO_PICKING_RULES rules

657:
658: CURSOR get_default_rsr(x_rule_name IN VARCHAR2) IS
659: SELECT par.release_seq_rule_id
660: FROM WSH_PARAMETERS par,
661: SO_PICKING_RULES rules
662: WHERE rules.picking_rule = x_rule_name
663: AND rules.warehouse_id = par.organization_id;
664:
665: x_batch_name VARCHAR2(30);

Line 820: FROM SO_PICKING_RULES

816: PARTIAL_ALLOWED_FLAG,
817: INCLUDE_PLANNED_LINES_FLAG,
818: AUTOCREATE_DELIVERY_FLAG,
819: operating_org -- Insert Operating Org
820: FROM SO_PICKING_RULES
821: WHERE PICKING_RULE = p_rule_name;
822:
823: WSH_UTIL.Write_Log('Inserted batch name ' || x_batch_name
824: || ' with batch_id ' ||