APPS.MRPP_CMERGE_FCST dependencies on MRP_SR_ASSIGNMENTS

Line 710: | Account merge procedure for the table, MRP_SR_ASSIGNMENTS

706: |
707: | PROCEDURE
708: | MRP_SA
709: | DESCRIPTION :
710: | Account merge procedure for the table, MRP_SR_ASSIGNMENTS
711: |
712: | NOTES:
713: |--------------------------------------------------------------*/
714:

Line 726: MRP_SR_ASSIGNMENTS.ASSIGNMENT_ID%TYPE

722: INDEX BY BINARY_INTEGER;
723: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
724:
725: TYPE ASSIGNMENT_ID_LIST_TYPE IS TABLE OF
726: MRP_SR_ASSIGNMENTS.ASSIGNMENT_ID%TYPE
727: INDEX BY BINARY_INTEGER;
728: PRIMARY_KEY_ID_LIST ASSIGNMENT_ID_LIST_TYPE;
729:
730: TYPE customer_id_LIST_TYPE IS TABLE OF

Line 731: MRP_SR_ASSIGNMENTS.customer_id%TYPE

727: INDEX BY BINARY_INTEGER;
728: PRIMARY_KEY_ID_LIST ASSIGNMENT_ID_LIST_TYPE;
729:
730: TYPE customer_id_LIST_TYPE IS TABLE OF
731: MRP_SR_ASSIGNMENTS.customer_id%TYPE
732: INDEX BY BINARY_INTEGER;
733: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
734: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
735:

Line 737: MRP_SR_ASSIGNMENTS.ship_to_site_id%TYPE

733: NUM_COL1_ORIG_LIST customer_id_LIST_TYPE;
734: NUM_COL1_NEW_LIST customer_id_LIST_TYPE;
735:
736: TYPE ship_to_site_id_LIST_TYPE IS TABLE OF
737: MRP_SR_ASSIGNMENTS.ship_to_site_id%TYPE
738: INDEX BY BINARY_INTEGER;
739: NUM_COL2_ORIG_LIST ship_to_site_id_LIST_TYPE;
740: NUM_COL2_NEW_LIST ship_to_site_id_LIST_TYPE;
741:

Line 748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m

744: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
745: ,yt.ASSIGNMENT_ID
746: ,yt.customer_id
747: ,yt.ship_to_site_id
748: FROM MRP_SR_ASSIGNMENTS yt, ra_customer_merges m
749: WHERE (
750: yt.customer_id = m.DUPLICATE_ID
751: OR yt.ship_to_site_id = m.DUPLICATE_SITE_ID
752: ) AND yt.assignment_type in (4,5,6)

Line 813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);

809: IF process_mode='LOCK' THEN
810: NULL;
811: ELSE
812: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);
814: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
815: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
816:
817: /* Fix for bug 1292873, part 2. */

Line 844: from mrp_sr_assignments m, ra_customer_merges r

840: m.ship_to_site_id,
841: m.sourcing_rule_type,
842: m.inventory_item_id,
843: m.category_id
844: from mrp_sr_assignments m, ra_customer_merges r
845: where (m.customer_id = r.duplicate_id
846: and m.ship_to_site_id = r.duplicate_site_id)
847: and m.assignment_type in (4, 5, 6)
848: and r.process_flag = 'N'

Line 871: delete /*+ index (msa mrp_sr_assignments_u1) */

867: l_category_id = rec.category_id and
868: l_customer_id = rec.customer_id and
869: l_customer_site_id = rec.customer_site_id) then
870:
871: delete /*+ index (msa mrp_sr_assignments_u1) */
872: from mrp_sr_assignments msa
873: where assignment_set_id = rec.assignment_set_id
874: and assignment_type = rec.assignment_type
875: and nvl(organization_id, -23453) = rec.organization_id

Line 872: from mrp_sr_assignments msa

868: l_customer_id = rec.customer_id and
869: l_customer_site_id = rec.customer_site_id) then
870:
871: delete /*+ index (msa mrp_sr_assignments_u1) */
872: from mrp_sr_assignments msa
873: where assignment_set_id = rec.assignment_set_id
874: and assignment_type = rec.assignment_type
875: and nvl(organization_id, -23453) = rec.organization_id
876: and nvl(customer_id, -23453) = rec.duplicate_id

Line 936: 'MRP_SR_ASSIGNMENTS',

932: LAST_UPDATE_LOGIN,
933: LAST_UPDATE_DATE,
934: LAST_UPDATED_BY
935: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
936: 'MRP_SR_ASSIGNMENTS',
937: MERGE_HEADER_ID_LIST(I),
938: PRIMARY_KEY_ID_LIST(I),
939: NUM_COL1_ORIG_LIST(I),
940: NUM_COL1_NEW_LIST(I),

Line 956: delete from mrp_sr_assignments

952: END IF;
953:
954: /* Fix for bug 12928793, part 1. */
955: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
956: delete from mrp_sr_assignments
957: where assignment_id IN
958: (SELECT
959: assignment_id
960: FROM mrp_sr_assignments

Line 960: FROM mrp_sr_assignments

956: delete from mrp_sr_assignments
957: where assignment_id IN
958: (SELECT
959: assignment_id
960: FROM mrp_sr_assignments
961: WHERE
962: (ASSIGNMENT_SET_ID ,
963: ASSIGNMENT_TYPE,
964: NVL(ORGANIZATION_ID, -23453),

Line 979: FROM mrp_sr_assignments

975: NVL(num_col2_new_list(I), -23453),
976: SOURCING_RULE_TYPE,
977: NVL(INVENTORY_ITEM_ID, -23453),
978: NVL(CATEGORY_ID, -23453)
979: FROM mrp_sr_assignments
980: WHERE assignment_id = primary_key_id_list(I)));
981:
982: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
983: UPDATE MRP_SR_ASSIGNMENTS yt SET

Line 983: UPDATE MRP_SR_ASSIGNMENTS yt SET

979: FROM mrp_sr_assignments
980: WHERE assignment_id = primary_key_id_list(I)));
981:
982: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
983: UPDATE MRP_SR_ASSIGNMENTS yt SET
984: customer_id=NUM_COL1_NEW_LIST(I)
985: ,ship_to_site_id=NUM_COL2_NEW_LIST(I)
986: , LAST_UPDATE_DATE=SYSDATE
987: , last_updated_by=arp_standard.profile.user_id