APPS.OE_INLINE_CUSTOMER_PUB dependencies on OE_LINES_IFACE_ALL

Line 3542: From Oe_Lines_Iface_All c

3538: From Oe_Headers_Iface_All b
3539: Where b.Orig_Ship_Address_Ref = a.customer_info_ref)
3540: UNION ALL
3541: (Select Orig_Ship_Address_Ref
3542: From Oe_Lines_Iface_All c
3543: Where c.Orig_Ship_Address_Ref = a.customer_info_ref));
3544: End If;
3545:
3546: If p_header_customer_rec.Orig_Bill_Address_Ref IS NOT NULL Then

Line 3568: From Oe_Lines_Iface_All c

3564: From Oe_Headers_Iface_All b
3565: Where b.Orig_Bill_Address_Ref = a.customer_info_ref)
3566: UNION ALL
3567: (Select Orig_Bill_Address_Ref
3568: From Oe_Lines_Iface_All c
3569: Where c.Orig_Bill_Address_Ref = a.customer_info_ref));
3570: End If;
3571:
3572: If p_header_customer_rec.Orig_Deliver_Address_Ref IS NOT NULL Then

Line 3592: From Oe_Lines_Iface_All c

3588: From Oe_Headers_Iface_All b
3589: Where b.Orig_Deliver_Address_Ref = a.customer_info_ref)
3590: UNION ALL
3591: (Select Orig_Deliver_Address_Ref
3592: From Oe_Lines_Iface_All c
3593: Where c.Orig_Deliver_Address_Ref = a.customer_info_ref));
3594: End If;
3595:
3596: If p_header_customer_rec.Ship_To_Contact_Ref IS NOT NULL Then

Line 3617: From Oe_Lines_Iface_All c

3613: From Oe_Headers_Iface_All b
3614: Where b.Ship_To_Contact_Ref = a.customer_info_ref)
3615: UNION ALL
3616: (Select Ship_To_Contact_Ref
3617: From Oe_Lines_Iface_All c
3618: Where c.Ship_To_Contact_Ref = a.customer_info_ref));
3619: End If;
3620:
3621: If p_header_customer_rec.Bill_To_Contact_Ref IS NOT NULL Then

Line 3641: From Oe_Lines_Iface_All c

3637: From Oe_Headers_Iface_All b
3638: Where b.Bill_To_Contact_Ref = a.customer_info_ref)
3639: UNION ALL
3640: (Select Bill_To_Contact_Ref
3641: From Oe_Lines_Iface_All c
3642: Where c.Bill_To_Contact_Ref = a.customer_info_ref));
3643: End If;
3644:
3645: If p_header_customer_rec.Deliver_To_Contact_Ref IS NOT NULL Then

Line 3666: From Oe_Lines_Iface_All c

3662: From Oe_Headers_Iface_All b
3663: Where b.Deliver_To_Contact_Ref = a.customer_info_ref)
3664: UNION ALL
3665: (Select Deliver_To_Contact_Ref
3666: From Oe_Lines_Iface_All c
3667: Where c.Deliver_To_Contact_Ref = a.customer_info_ref));
3668: End If;
3669:
3670: For i In 1..p_line_customer_tbl.COUNT Loop

Line 3687: From Oe_Lines_Iface_All b

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)
3689: UNION ALL
3690: (Select Orig_Ship_Address_Ref
3691: From Oe_Headers_Iface_All c

Line 3711: From Oe_Lines_Iface_All b

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)
3713: UNION ALL
3714: (Select Orig_Bill_Address_Ref
3715: From Oe_Headers_Iface_All c

Line 3735: From Oe_Lines_Iface_All b

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)
3737: UNION ALL
3738: (Select Orig_Deliver_Address_Ref
3739: From Oe_Headers_Iface_All c

Line 3760: From Oe_Lines_Iface_All b

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)
3762: UNION ALL
3763: (Select Ship_To_Contact_Ref
3764: From Oe_Headers_Iface_All c

Line 3785: From Oe_Lines_Iface_All b

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)
3787: UNION ALL
3788: (Select Bill_To_Contact_Ref
3789: From Oe_Headers_Iface_All c

Line 3810: From Oe_Lines_Iface_All b

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)
3812: UNION ALL
3813: (Select Deliver_To_Contact_Ref
3814: From Oe_Headers_Iface_All c