APPS.OE_INLINE_CUSTOMER_PUB dependencies on OE_LINES_IFACE_ALL

Line 3543: From Oe_Lines_Iface_All c

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

Line 3569: From Oe_Lines_Iface_All c

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

Line 3593: From Oe_Lines_Iface_All c

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

Line 3618: From Oe_Lines_Iface_All c

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

Line 3642: From Oe_Lines_Iface_All c

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

Line 3667: From Oe_Lines_Iface_All c

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

Line 3688: From Oe_Lines_Iface_All b

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

Line 3712: From Oe_Lines_Iface_All b

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

Line 3736: From Oe_Lines_Iface_All b

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

Line 3761: From Oe_Lines_Iface_All b

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

Line 3786: From Oe_Lines_Iface_All b

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

Line 3811: From Oe_Lines_Iface_All b

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