eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on EGO_ROUTE_LIST_INF

Line 626: SELECT Ego_route_list_inf(

622: --cursor for list of routings in given batch
623:
624: CURSOR l_routing_list_c(batch_id_route NUMBER,purge_criteria VARCHAR2)IS
625:
626: SELECT Ego_route_list_inf(
627: BATCH_ID,
628: ORGANIZATION_ID,
629: REQUEST_ID,
630: ASSEMBLY_ITEM_ID,

Line 642: TYPE routing_table IS TABLE OF Ego_route_list_inf;

638: AND I.PROCESS_FLAG IN ( Decode(purge_criteria,'SUCCESS',7,'ERROR',3,-123456) , Decode(purge_criteria,'SUCCESS',7,'ERROR',6,-123456) )
639: );
640:
641:
642: TYPE routing_table IS TABLE OF Ego_route_list_inf;
643: l_routing_table routing_table:=null;
644: routing_num NUMBER := 0;
645:
646:

Line 833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id

829:
830: FORALL op IN l_routing_table.first .. l_routing_table.last
831:
832: DELETE FROM bom_op_resources_interface bori
833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

Line 834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

830: FORALL op IN l_routing_table.first .. l_routing_table.last
831:
832: DELETE FROM bom_op_resources_interface bori
833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

Line 835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id

831:
832: DELETE FROM bom_op_resources_interface bori
833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

Line 836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

832: DELETE FROM bom_op_resources_interface bori
833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

Line 837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

Line 838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
842: )

Line 839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
842: )
843: );

Line 840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
842: )
843: );
844:

Line 841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

837: AND ( bori.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
838: OR ( bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
839: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
840: AND Nvl(bori.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
841: AND (bori.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
842: )
843: );
844:
845: FOR i IN l_routing_table.first .. l_routing_table.last LOOP

Line 856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id

852:
853: FORALL op IN l_routing_table.first .. l_routing_table.last
854:
855: DELETE FROM bom_sub_op_resources_interface bsr
856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

Line 857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

853: FORALL op IN l_routing_table.first .. l_routing_table.last
854:
855: DELETE FROM bom_sub_op_resources_interface bsr
856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

Line 858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id

854:
855: DELETE FROM bom_sub_op_resources_interface bsr
856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

Line 859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

855: DELETE FROM bom_sub_op_resources_interface bsr
856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

Line 860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

Line 861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
865: )

Line 862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
865: )
866: );

Line 863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
865: )
866: );
867:

Line 864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

860: AND ( bsr.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
861: OR ( bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
862: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
863: AND Nvl(bsr.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
864: AND (bsr.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
865: )
866: );
867:
868: FOR i IN l_routing_table.first .. l_routing_table.last LOOP

Line 890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id

886:
887: FORALL op IN l_routing_table.first .. l_routing_table.last
888:
889: DELETE FROM bom_op_sequences_interface bseq
890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

Line 891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

887: FORALL op IN l_routing_table.first .. l_routing_table.last
888:
889: DELETE FROM bom_op_sequences_interface bseq
890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

Line 892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id

888:
889: DELETE FROM bom_op_sequences_interface bseq
890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

Line 893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

889: DELETE FROM bom_op_sequences_interface bseq
890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

Line 894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

Line 895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
899: )

Line 896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
899: )
900: );

Line 897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)

893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
899: )
900: );
901:

Line 898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)

894: AND ( bseq.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
895: OR ( bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
896: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
897: AND Nvl(bseq.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0)
898: AND (bseq.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL)
899: )
900: );
901:
902: FOR i IN l_routing_table.first .. l_routing_table.last LOOP

Line 913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id

909:
910: FORALL op IN l_routing_table.first .. l_routing_table.last
911:
912: DELETE FROM bom_op_routings_interface brou
913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

Line 914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id

910: FORALL op IN l_routing_table.first .. l_routing_table.last
911:
912: DELETE FROM bom_op_routings_interface brou
913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND

Line 915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id

911:
912: DELETE FROM bom_op_routings_interface brou
913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND

Line 916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

912: DELETE FROM bom_op_routings_interface brou
913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND

Line 917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID

913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND
921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )

Line 918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND

914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND
921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )
922: )

Line 919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND

915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND
921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )
922: )
923: );

Line 920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND

916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id
917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND
921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )
922: )
923: );
924:

Line 921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )

917: AND ( brou.ROUTING_SEQUENCE_ID = TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID
918: OR ( brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id AND
919: brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id AND
920: Nvl(brou.ALTERNATE_ROUTING_DESIGNATOR,0) = Nvl(TREAT(l_routing_table(op) AS Ego_route_list_inf).alternate_routing_designator,0) AND
921: (brou.ROUTING_SEQUENCE_ID IS NULL OR TREAT(l_routing_table(op) AS Ego_route_list_inf).ROUTING_SEQUENCE_ID IS NULL )
922: )
923: );
924:
925: FOR i IN l_routing_table.first .. l_routing_table.last LOOP