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 2562: from oe_customer_info_iface_all

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

Line 3160: Update oe_customer_info_iface_all

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

Line 3324: from oe_customer_info_iface_all

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

Line 3496: From oe_customer_info_iface_all a

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

Line 3506: From oe_customer_info_iface_all a

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

Line 3507: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3515: From oe_customer_info_iface_all a

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

Line 3526: From oe_customer_info_iface_all a

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

Line 3527: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3535: From oe_customer_info_iface_all a

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

Line 3550: From oe_customer_info_iface_all a

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

Line 3551: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3561: From oe_customer_info_iface_all a

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

Line 3576: From oe_customer_info_iface_all a

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

Line 3577: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3585: From oe_customer_info_iface_all a

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

Line 3599: From oe_customer_info_iface_all a

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

Line 3600: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3610: From oe_customer_info_iface_all a

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

Line 3624: From oe_customer_info_iface_all a

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

Line 3625: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3634: From oe_customer_info_iface_all a

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

Line 3649: From oe_customer_info_iface_all a

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

Line 3650: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3659: From oe_customer_info_iface_all a

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

Line 3674: From oe_customer_info_iface_all a

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

Line 3675: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3684: From oe_customer_info_iface_all a

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

Line 3698: From oe_customer_info_iface_all a

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

Line 3699: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3708: From oe_customer_info_iface_all a

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

Line 3722: From oe_customer_info_iface_all a

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

Line 3723: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3732: From oe_customer_info_iface_all a

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

Line 3747: From oe_customer_info_iface_all a

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

Line 3748: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3757: From oe_customer_info_iface_all a

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

Line 3772: From oe_customer_info_iface_all a

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

Line 3773: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3782: From oe_customer_info_iface_all a

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

Line 3796: From oe_customer_info_iface_all a

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

Line 3797: Where customer_info_ref = (Select Parent_Customer_Ref from oe_customer_info_iface_all

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

Line 3807: From oe_customer_info_iface_all a

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