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.OE_INLINE_CUSTOMER_PUB dependencies on OE_CUSTOMER_INFO_IFACE_ALL

Line 166: Update Oe_Customer_Info_Iface_All

162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'ENTERING PROCEDURE UPDATE_ERROR_FLAG' ) ;
164: END IF;
165:
166: Update Oe_Customer_Info_Iface_All
167: Set Error_Flag = 'Y'
168: Where rowid = p_rowid;
169: Commit;
170:

Line 211: FROM oe_customer_info_iface_all

207: END IF;
208:
209: SELECT new_address_id_ship,new_address_id_bill,new_address_id_Deliver
210: into l_address_id_ship, l_address_id_bill, l_address_id_deliver
211: FROM oe_customer_info_iface_all
212: WHERE rowid = row_id
213: FOR UPDATE NOWAIT;
214:
215: If type_of_address = 'SHIP_TO' AND

Line 218: UPDATE oe_customer_info_iface_all

214:
215: If type_of_address = 'SHIP_TO' AND
216: l_address_id_ship is NULL Then
217:
218: UPDATE oe_customer_info_iface_all
219: SET new_address_id_ship = usage_site_id
220: WHERE rowid = row_id;
221:
222: Elsif type_of_address = 'BILL_TO' AND

Line 225: UPDATE oe_customer_info_iface_all

221:
222: Elsif type_of_address = 'BILL_TO' AND
223: l_address_id_bill is NULL Then
224:
225: UPDATE oe_customer_info_iface_all
226: SET new_address_id_bill = usage_site_id
227: WHERE rowid = row_id;
228:
229: Elsif type_of_address = 'DELIVER_TO' AND

Line 231: UPDATE oe_customer_info_iface_all

227: WHERE rowid = row_id;
228:
229: Elsif type_of_address = 'DELIVER_TO' AND
230: l_address_id_deliver is NULL Then
231: UPDATE oe_customer_info_iface_all
232: SET new_address_id_Deliver = usage_site_id
233: WHERE rowid = row_id;
234: End if;
235: Commit;

Line 787: from oe_customer_info_iface_all

783: global_attribute19,
784: global_attribute20,
785: rowid,
786: phone_country_code
787: from oe_customer_info_iface_all
788: where customer_info_ref = l_customer_info_ref
789: and customer_info_type_code = 'ACCOUNT';
790:
791: -- End of Cursor definition for l_customer_info_cur }

Line 1110: Update oe_customer_info_iface_all

1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add( 'NEW PARTY ID => ' || X_CUST_PARTY_ID ) ;
1108: END IF;
1109:
1110: Update oe_customer_info_iface_all
1111: Set New_Party_Id = x_cust_party_id,
1112: New_Party_Number = l_party_number,
1113: New_Account_Id = x_cust_account_id,
1114: New_Account_Number = x_cust_account_Number

Line 1264: Update oe_customer_info_iface_all

1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add( 'NEW PARTY ID => ' || X_CUST_PARTY_ID ) ;
1262: END IF;
1263:
1264: Update oe_customer_info_iface_all
1265: Set New_Party_Id = x_cust_party_id,
1266: New_Party_Number = l_party_number,
1267: New_Account_Id = x_cust_account_id,
1268: New_Account_Number = x_cust_account_Number

Line 1547: From oe_customer_info_iface_all

1543: global_attribute18,
1544: global_attribute19,
1545: global_attribute20,
1546: rowid
1547: From oe_customer_info_iface_all
1548: WHERE customer_info_ref = l_customer_info_ref
1549: AND customer_info_type_code = 'ADDRESS';
1550:
1551: l_customer_info_id Number;

Line 2563: from oe_customer_info_iface_all

2559: is_bill_to_address,
2560: is_deliver_to_address,
2561: rowid,
2562: phone_country_code
2563: from oe_customer_info_iface_all
2564: where customer_info_ref = l_customer_info_ref
2565: and customer_info_type_code = 'CONTACT';
2566:
2567: -- End of Cursor definition for l_contact_info_cur }

Line 3161: Update oe_customer_info_iface_all

3157: -- End of select to get name
3158:
3159: -- Now Update the table with the new values
3160:
3161: Update oe_customer_info_iface_all
3162: Set New_Contact_Id = x_contact_id,
3163: New_Party_Id = x_rel_party_id,
3164: is_ship_to_address =
3165: decode(l_type_of_contact,'SHIP_TO','Y',is_ship_to_address),

Line 3325: from oe_customer_info_iface_all

3321: global_attribute17,
3322: global_attribute18,
3323: global_attribute19,
3324: global_attribute20
3325: from oe_customer_info_iface_all
3326: where customer_info_ref = l_customer_info_ref
3327: and customer_info_type_code = 'ADDRESS';
3328:
3329: -- End of Cursor definition for l_address_info_cur }

Line 3497: From oe_customer_info_iface_all a

3493: END IF;
3494:
3495: If p_header_customer_rec.Orig_Sys_Customer_Ref IS NOT NULL Then
3496: Delete
3497: From oe_customer_info_iface_all a
3498: Where customer_info_ref = p_header_customer_rec.Orig_Sys_Customer_Ref
3499: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3500: From Oe_Headers_Iface_All b
3501: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);

Line 3507: From oe_customer_info_iface_all a

3503:
3504: If p_header_customer_rec.Sold_To_Contact_Ref IS NOT NULL Then
3505:
3506: Delete
3507: From oe_customer_info_iface_all a
3508: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3509: where customer_info_ref = p_header_customer_rec.Sold_To_Contact_Ref
3510: and customer_info_type_code = 'CONTACT')
3511: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3508: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3504: If p_header_customer_rec.Sold_To_Contact_Ref IS NOT NULL Then
3505:
3506: Delete
3507: From oe_customer_info_iface_all a
3508: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3509: where customer_info_ref = p_header_customer_rec.Sold_To_Contact_Ref
3510: and customer_info_type_code = 'CONTACT')
3511: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3512: From Oe_Headers_Iface_All b

Line 3516: From oe_customer_info_iface_all a

3512: From Oe_Headers_Iface_All b
3513: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3514:
3515: Delete
3516: From oe_customer_info_iface_all a
3517: Where customer_info_ref = p_header_customer_rec.Sold_To_Contact_Ref
3518: And customer_info_ref Not In (Select Sold_To_Contact_Ref
3519: From Oe_Headers_Iface_All b
3520: Where b.Sold_To_Contact_Ref = a.customer_info_ref);

Line 3527: From oe_customer_info_iface_all a

3523: If p_header_customer_rec.Orig_Ship_Address_Ref IS NOT NULL Then
3524:
3525:
3526: Delete
3527: From oe_customer_info_iface_all a
3528: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3529: where customer_info_ref = p_header_customer_rec.Orig_Ship_Address_Ref
3530: and customer_info_type_code = 'ADDRESS' )
3531: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3528: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3524:
3525:
3526: Delete
3527: From oe_customer_info_iface_all a
3528: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3529: where customer_info_ref = p_header_customer_rec.Orig_Ship_Address_Ref
3530: and customer_info_type_code = 'ADDRESS' )
3531: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3532: From Oe_Headers_Iface_All b

Line 3536: From oe_customer_info_iface_all a

3532: From Oe_Headers_Iface_All b
3533: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3534:
3535: Delete
3536: From oe_customer_info_iface_all a
3537: Where customer_info_ref = p_header_customer_rec.Orig_Ship_Address_Ref
3538: And customer_info_ref Not In ((Select Orig_Ship_Address_Ref
3539: From Oe_Headers_Iface_All b
3540: Where b.Orig_Ship_Address_Ref = a.customer_info_ref)

Line 3551: From oe_customer_info_iface_all a

3547: If p_header_customer_rec.Orig_Bill_Address_Ref IS NOT NULL Then
3548:
3549:
3550: Delete
3551: From oe_customer_info_iface_all a
3552: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3553: where customer_info_ref = p_header_customer_rec.Orig_Bill_Address_Ref
3554: and customer_info_type_code = 'ADDRESS')
3555: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3552: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3548:
3549:
3550: Delete
3551: From oe_customer_info_iface_all a
3552: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3553: where customer_info_ref = p_header_customer_rec.Orig_Bill_Address_Ref
3554: and customer_info_type_code = 'ADDRESS')
3555: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3556: From Oe_Headers_Iface_All b

Line 3562: From oe_customer_info_iface_all a

3558:
3559:
3560:
3561: Delete
3562: From oe_customer_info_iface_all a
3563: Where customer_info_ref = p_header_customer_rec.Orig_Bill_Address_Ref
3564: And customer_info_ref Not In ((Select Orig_Bill_Address_Ref
3565: From Oe_Headers_Iface_All b
3566: Where b.Orig_Bill_Address_Ref = a.customer_info_ref)

Line 3577: From oe_customer_info_iface_all a

3573: If p_header_customer_rec.Orig_Deliver_Address_Ref IS NOT NULL Then
3574:
3575:
3576: Delete
3577: From oe_customer_info_iface_all a
3578: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3579: where customer_info_ref = p_header_customer_rec.Orig_Deliver_Address_Ref
3580: and customer_info_type_code = 'ADDRESS')
3581: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3578: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3574:
3575:
3576: Delete
3577: From oe_customer_info_iface_all a
3578: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3579: where customer_info_ref = p_header_customer_rec.Orig_Deliver_Address_Ref
3580: and customer_info_type_code = 'ADDRESS')
3581: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3582: From Oe_Headers_Iface_All b

Line 3586: From oe_customer_info_iface_all a

3582: From Oe_Headers_Iface_All b
3583: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3584:
3585: Delete
3586: From oe_customer_info_iface_all a
3587: Where customer_info_ref = p_header_customer_rec.Orig_Deliver_Address_Ref
3588: And customer_info_ref Not In ((Select Orig_Deliver_Address_Ref
3589: From Oe_Headers_Iface_All b
3590: Where b.Orig_Deliver_Address_Ref = a.customer_info_ref)

Line 3600: From oe_customer_info_iface_all a

3596:
3597: If p_header_customer_rec.Ship_To_Contact_Ref IS NOT NULL Then
3598:
3599: Delete
3600: From oe_customer_info_iface_all a
3601: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3602: where customer_info_ref = p_header_customer_rec.Ship_To_Contact_Ref
3603: and customer_info_type_code = 'CONTACT')
3604: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3601: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3597: If p_header_customer_rec.Ship_To_Contact_Ref IS NOT NULL Then
3598:
3599: Delete
3600: From oe_customer_info_iface_all a
3601: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3602: where customer_info_ref = p_header_customer_rec.Ship_To_Contact_Ref
3603: and customer_info_type_code = 'CONTACT')
3604: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3605: From Oe_Headers_Iface_All b

Line 3611: From oe_customer_info_iface_all a

3607:
3608:
3609:
3610: Delete
3611: From oe_customer_info_iface_all a
3612: Where customer_info_ref = p_header_customer_rec.Ship_To_Contact_Ref
3613: And customer_info_ref Not In ((Select Ship_To_Contact_Ref
3614: From Oe_Headers_Iface_All b
3615: Where b.Ship_To_Contact_Ref = a.customer_info_ref)

Line 3625: From oe_customer_info_iface_all a

3621:
3622: If p_header_customer_rec.Bill_To_Contact_Ref IS NOT NULL Then
3623:
3624: Delete
3625: From oe_customer_info_iface_all a
3626: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3627: where customer_info_ref = p_header_customer_rec.Bill_To_Contact_Ref
3628: and customer_info_type_code = 'CONTACT')
3629: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3626: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3622: If p_header_customer_rec.Bill_To_Contact_Ref IS NOT NULL Then
3623:
3624: Delete
3625: From oe_customer_info_iface_all a
3626: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3627: where customer_info_ref = p_header_customer_rec.Bill_To_Contact_Ref
3628: and customer_info_type_code = 'CONTACT')
3629: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3630: From Oe_Headers_Iface_All b

Line 3635: From oe_customer_info_iface_all a

3631: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3632:
3633:
3634: Delete
3635: From oe_customer_info_iface_all a
3636: Where customer_info_ref = p_header_customer_rec.Bill_To_Contact_Ref
3637: And customer_info_ref Not In ((Select Bill_To_Contact_Ref
3638: From Oe_Headers_Iface_All b
3639: Where b.Bill_To_Contact_Ref = a.customer_info_ref)

Line 3650: From oe_customer_info_iface_all a

3646: If p_header_customer_rec.Deliver_To_Contact_Ref IS NOT NULL Then
3647:
3648:
3649: Delete
3650: From oe_customer_info_iface_all a
3651: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3652: where customer_info_ref = p_header_customer_rec.Deliver_To_Contact_Ref
3653: and customer_info_type_code = 'CONTACT')
3654: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3651: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3647:
3648:
3649: Delete
3650: From oe_customer_info_iface_all a
3651: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3652: where customer_info_ref = p_header_customer_rec.Deliver_To_Contact_Ref
3653: and customer_info_type_code = 'CONTACT')
3654: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3655: From Oe_Headers_Iface_All b

Line 3660: From oe_customer_info_iface_all a

3656: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3657:
3658:
3659: Delete
3660: From oe_customer_info_iface_all a
3661: Where customer_info_ref = p_header_customer_rec.Deliver_To_Contact_Ref
3662: And customer_info_ref Not In ((Select Deliver_To_Contact_Ref
3663: From Oe_Headers_Iface_All b
3664: Where b.Deliver_To_Contact_Ref = a.customer_info_ref)

Line 3675: From oe_customer_info_iface_all a

3671: For i In 1..p_line_customer_tbl.COUNT Loop
3672: If p_line_customer_tbl(i).Orig_Ship_Address_Ref IS NOT NULL Then
3673:
3674: Delete
3675: From oe_customer_info_iface_all a
3676: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3677: where customer_info_ref = p_line_customer_tbl(i).Orig_Ship_Address_Ref
3678: and customer_info_type_code = 'ADDRESS' )
3679: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3676: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3672: If p_line_customer_tbl(i).Orig_Ship_Address_Ref IS NOT NULL Then
3673:
3674: Delete
3675: From oe_customer_info_iface_all a
3676: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3677: where customer_info_ref = p_line_customer_tbl(i).Orig_Ship_Address_Ref
3678: and customer_info_type_code = 'ADDRESS' )
3679: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3680: From Oe_Headers_Iface_All b

Line 3685: From oe_customer_info_iface_all a

3681: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3682:
3683:
3684: Delete
3685: From oe_customer_info_iface_all a
3686: Where customer_info_ref = p_line_customer_tbl(i).Orig_Ship_Address_Ref
3687: And customer_info_ref Not In ((Select Orig_Ship_Address_Ref
3688: From Oe_Lines_Iface_All b
3689: Where b.Orig_Ship_Address_Ref = a.customer_info_ref)

Line 3699: From oe_customer_info_iface_all a

3695:
3696: If p_line_customer_tbl(i).Orig_Bill_Address_Ref IS NOT NULL Then
3697:
3698: Delete
3699: From oe_customer_info_iface_all a
3700: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3701: where customer_info_ref = p_line_customer_tbl(i).Orig_Bill_Address_Ref
3702: and customer_info_type_code = 'ADDRESS' )
3703: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3700: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3696: If p_line_customer_tbl(i).Orig_Bill_Address_Ref IS NOT NULL Then
3697:
3698: Delete
3699: From oe_customer_info_iface_all a
3700: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3701: where customer_info_ref = p_line_customer_tbl(i).Orig_Bill_Address_Ref
3702: and customer_info_type_code = 'ADDRESS' )
3703: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3704: From Oe_Headers_Iface_All b

Line 3709: From oe_customer_info_iface_all a

3705: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3706:
3707:
3708: Delete
3709: From oe_customer_info_iface_all a
3710: Where customer_info_ref = p_line_customer_tbl(i).Orig_Bill_Address_Ref
3711: And customer_info_ref Not In ((Select Orig_Bill_Address_Ref
3712: From Oe_Lines_Iface_All b
3713: Where b.Orig_Bill_Address_Ref = a.customer_info_ref)

Line 3723: From oe_customer_info_iface_all a

3719:
3720: If p_line_customer_tbl(i).Orig_Deliver_Address_Ref IS NOT NULL Then
3721:
3722: Delete
3723: From oe_customer_info_iface_all a
3724: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3725: where customer_info_ref = p_line_customer_tbl(i).Orig_Deliver_Address_Ref
3726: and customer_info_type_code = 'ADDRESS')
3727: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3724: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3720: If p_line_customer_tbl(i).Orig_Deliver_Address_Ref IS NOT NULL Then
3721:
3722: Delete
3723: From oe_customer_info_iface_all a
3724: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3725: where customer_info_ref = p_line_customer_tbl(i).Orig_Deliver_Address_Ref
3726: and customer_info_type_code = 'ADDRESS')
3727: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3728: From Oe_Headers_Iface_All b

Line 3733: From oe_customer_info_iface_all a

3729: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3730:
3731:
3732: Delete
3733: From oe_customer_info_iface_all a
3734: Where customer_info_ref = p_line_customer_tbl(i).Orig_Deliver_Address_Ref
3735: And customer_info_ref Not In ((Select Orig_Deliver_Address_Ref
3736: From Oe_Lines_Iface_All b
3737: Where b.Orig_Deliver_Address_Ref = a.customer_info_ref)

Line 3748: From oe_customer_info_iface_all a

3744: If p_line_customer_tbl(i).Ship_To_Contact_Ref IS NOT NULL Then
3745:
3746:
3747: Delete
3748: From oe_customer_info_iface_all a
3749: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3750: where customer_info_ref = p_line_customer_tbl(i).Ship_To_Contact_Ref
3751: and customer_info_type_code = 'CONTACT')
3752: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3749: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3745:
3746:
3747: Delete
3748: From oe_customer_info_iface_all a
3749: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3750: where customer_info_ref = p_line_customer_tbl(i).Ship_To_Contact_Ref
3751: and customer_info_type_code = 'CONTACT')
3752: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3753: From Oe_Headers_Iface_All b

Line 3758: From oe_customer_info_iface_all a

3754: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3755:
3756:
3757: Delete
3758: From oe_customer_info_iface_all a
3759: Where customer_info_ref = p_line_customer_tbl(i).Ship_To_Contact_Ref
3760: And customer_info_ref Not In ((Select Ship_To_Contact_Ref
3761: From Oe_Lines_Iface_All b
3762: Where b.Ship_To_Contact_Ref = a.customer_info_ref)

Line 3773: From oe_customer_info_iface_all a

3769: If p_line_customer_tbl(i).Bill_To_Contact_Ref IS NOT NULL Then
3770:
3771:
3772: Delete
3773: From oe_customer_info_iface_all a
3774: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3775: where customer_info_ref = p_line_customer_tbl(i).Bill_To_Contact_Ref
3776: and customer_info_type_code = 'CONTACT')
3777: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3774: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3770:
3771:
3772: Delete
3773: From oe_customer_info_iface_all a
3774: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3775: where customer_info_ref = p_line_customer_tbl(i).Bill_To_Contact_Ref
3776: and customer_info_type_code = 'CONTACT')
3777: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3778: From Oe_Headers_Iface_All b

Line 3783: From oe_customer_info_iface_all a

3779: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3780:
3781:
3782: Delete
3783: From oe_customer_info_iface_all a
3784: Where customer_info_ref = p_line_customer_tbl(i).Bill_To_Contact_Ref
3785: And customer_info_ref Not In ((Select Bill_To_Contact_Ref
3786: From Oe_Lines_Iface_All b
3787: Where b.Bill_To_Contact_Ref = a.customer_info_ref)

Line 3797: From oe_customer_info_iface_all a

3793:
3794: If p_line_customer_tbl(i).Deliver_To_Contact_Ref IS NOT NULL Then
3795:
3796: Delete
3797: From oe_customer_info_iface_all a
3798: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3799: where customer_info_ref = p_line_customer_tbl(i).Deliver_To_Contact_Ref
3800: and customer_info_type_code = 'CONTACT')
3801: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref

Line 3798: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

3794: If p_line_customer_tbl(i).Deliver_To_Contact_Ref IS NOT NULL Then
3795:
3796: Delete
3797: From oe_customer_info_iface_all a
3798: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all
3799: where customer_info_ref = p_line_customer_tbl(i).Deliver_To_Contact_Ref
3800: and customer_info_type_code = 'CONTACT')
3801: And customer_info_ref Not In (Select Orig_Sys_Customer_Ref
3802: From Oe_Headers_Iface_All b

Line 3808: From oe_customer_info_iface_all a

3804:
3805:
3806:
3807: Delete
3808: From oe_customer_info_iface_all a
3809: Where customer_info_ref = p_line_customer_tbl(i).Deliver_To_Contact_Ref
3810: And customer_info_ref Not In ((Select Deliver_To_Contact_Ref
3811: From Oe_Lines_Iface_All b
3812: Where b.Deliver_To_Contact_Ref = a.customer_info_ref)