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_HEADERS_IFACE_ALL

Line 3500: From Oe_Headers_Iface_All b

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);
3502: End If;
3503:
3504: If p_header_customer_rec.Sold_To_Contact_Ref IS NOT NULL Then

Line 3512: From Oe_Headers_Iface_All b

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
3513: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3514:
3515: Delete
3516: From oe_customer_info_iface_all a

Line 3519: From Oe_Headers_Iface_All b

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);
3521: End If;
3522:
3523: If p_header_customer_rec.Orig_Ship_Address_Ref IS NOT NULL Then

Line 3532: From Oe_Headers_Iface_All b

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
3533: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3534:
3535: Delete
3536: From oe_customer_info_iface_all a

Line 3539: From Oe_Headers_Iface_All b

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)
3541: UNION ALL
3542: (Select Orig_Ship_Address_Ref
3543: From Oe_Lines_Iface_All c

Line 3556: From Oe_Headers_Iface_All b

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
3557: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3558:
3559:
3560:

Line 3565: From Oe_Headers_Iface_All b

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)
3567: UNION ALL
3568: (Select Orig_Bill_Address_Ref
3569: From Oe_Lines_Iface_All c

Line 3582: From Oe_Headers_Iface_All b

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
3583: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3584:
3585: Delete
3586: From oe_customer_info_iface_all a

Line 3589: From Oe_Headers_Iface_All b

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)
3591: UNION ALL
3592: (Select Orig_Deliver_Address_Ref
3593: From Oe_Lines_Iface_All c

Line 3605: From Oe_Headers_Iface_All b

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
3606: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3607:
3608:
3609:

Line 3614: From Oe_Headers_Iface_All b

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)
3616: UNION ALL
3617: (Select Ship_To_Contact_Ref
3618: From Oe_Lines_Iface_All c

Line 3630: From Oe_Headers_Iface_All b

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
3631: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3632:
3633:
3634: Delete

Line 3638: From Oe_Headers_Iface_All b

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)
3640: UNION ALL
3641: (Select Bill_To_Contact_Ref
3642: From Oe_Lines_Iface_All c

Line 3655: From Oe_Headers_Iface_All b

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
3656: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3657:
3658:
3659: Delete

Line 3663: From Oe_Headers_Iface_All b

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)
3665: UNION ALL
3666: (Select Deliver_To_Contact_Ref
3667: From Oe_Lines_Iface_All c

Line 3680: From Oe_Headers_Iface_All b

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
3681: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3682:
3683:
3684: Delete

Line 3692: From Oe_Headers_Iface_All c

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
3693: Where c.Orig_Ship_Address_Ref = a.customer_info_ref));
3694: End If;
3695:
3696: If p_line_customer_tbl(i).Orig_Bill_Address_Ref IS NOT NULL Then

Line 3704: From Oe_Headers_Iface_All b

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
3705: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3706:
3707:
3708: Delete

Line 3716: From Oe_Headers_Iface_All c

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
3717: Where c.Orig_Bill_Address_Ref = a.customer_info_ref));
3718: End If;
3719:
3720: If p_line_customer_tbl(i).Orig_Deliver_Address_Ref IS NOT NULL Then

Line 3728: From Oe_Headers_Iface_All b

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
3729: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3730:
3731:
3732: Delete

Line 3740: From Oe_Headers_Iface_All c

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
3741: Where c.Orig_Deliver_Address_Ref = a.customer_info_ref));
3742: End If;
3743:
3744: If p_line_customer_tbl(i).Ship_To_Contact_Ref IS NOT NULL Then

Line 3753: From Oe_Headers_Iface_All b

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
3754: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3755:
3756:
3757: Delete

Line 3765: From Oe_Headers_Iface_All c

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
3766: Where c.Ship_To_Contact_Ref = a.customer_info_ref));
3767: End If;
3768:
3769: If p_line_customer_tbl(i).Bill_To_Contact_Ref IS NOT NULL Then

Line 3778: From Oe_Headers_Iface_All b

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
3779: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3780:
3781:
3782: Delete

Line 3790: From Oe_Headers_Iface_All c

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
3791: Where c.Bill_To_Contact_Ref = a.customer_info_ref));
3792: End If;
3793:
3794: If p_line_customer_tbl(i).Deliver_To_Contact_Ref IS NOT NULL Then

Line 3802: From Oe_Headers_Iface_All b

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
3803: Where b.Orig_Sys_Customer_Ref = a.customer_info_ref);
3804:
3805:
3806:

Line 3815: From Oe_Headers_Iface_All c

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
3816: Where c.Deliver_To_Contact_Ref = a.customer_info_ref));
3817: End If;
3818:
3819: End Loop;