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.QP_BULK_VALIDATE dependencies on QP_NUMBER

Line 3488: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3484: and pia.orig_sys_line_ref=pb.orig_sys_line_ref
3485: )
3486: -- Got the remaining Price Break Lines that are not being updated in this request
3487: AND (
3488: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3489: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3490: ) -- New Price Break To is greater than (or equal to) New Price Break From
3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

Line 3489: qp_number.canonical_to_number(pa.pricing_attr_value_to)

3485: )
3486: -- Got the remaining Price Break Lines that are not being updated in this request
3487: AND (
3488: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3489: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3490: ) -- New Price Break To is greater than (or equal to) New Price Break From
3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)

Line 3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

3488: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3489: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3490: ) -- New Price Break To is greater than (or equal to) New Price Break From
3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break

Line 3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3489: qp_number.canonical_to_number(pa.pricing_attr_value_to)
3490: ) -- New Price Break To is greater than (or equal to) New Price Break From
3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break
3497: OR

Line 3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3490: ) -- New Price Break To is greater than (or equal to) New Price Break From
3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break
3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

Line 3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3491: OR
3492: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3493: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break
3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)

Line 3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

3494: AND qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break
3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break

Line 3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3495: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3496: ) -- New Price Break From in between Old Price Break
3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break
3503: OR

Line 3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3496: ) -- New Price Break From in between Old Price Break
3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break
3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

Line 3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3497: OR
3498: ( qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3499: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break
3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)

Line 3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <

3500: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break
3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3506: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3507: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3508: ) -- Old Price Break in between New Price Break

Line 3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3501: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3502: ) -- New Price Break To in between Old Price Break
3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3506: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3507: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3508: ) -- Old Price Break in between New Price Break
3509: );

Line 3506: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3502: ) -- New Price Break To in between Old Price Break
3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3506: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3507: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3508: ) -- Old Price Break in between New Price Break
3509: );
3510:

Line 3507: qp_number.canonical_to_number(pb.pricing_attr_value_to)

3503: OR
3504: ( qp_number.canonical_to_number(pa.pricing_attr_value_from) <
3505: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3506: AND qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3507: qp_number.canonical_to_number(pb.pricing_attr_value_to)
3508: ) -- Old Price Break in between New Price Break
3509: );
3510:
3511: Cursor C_old_cont_grp_break_line(p_orig_sys_line_ref VARCHAR2,

Line 3703: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369

3699: AND pa.request_id=p_request_id
3700: AND pb.request_id=p_request_id
3701: -- end changes
3702:
3703: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR

Line 3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

3700: AND pb.request_id=p_request_id
3701: -- end changes
3702:
3703: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

Line 3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=

3701: -- end changes
3702:
3703: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

Line 3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3702:
3703: AND (qp_number.canonical_to_number(pa.pricing_attr_value_from) < -- 4713369
3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >

Line 3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=

3704: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR

Line 3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND

3705: qp_number.canonical_to_number(pa.pricing_attr_value_from) >=
3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=

Line 3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >

3706: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND

Line 3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)

3707: OR
3708: qp_number.canonical_to_number(pa.pricing_attr_value_to) <=
3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=

Line 3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=

3709: qp_number.canonical_to_number(pb.pricing_attr_value_to) AND
3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3717:

Line 3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND

3710: qp_number.canonical_to_number(pa.pricing_attr_value_to) >
3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3717:
3718: BEGIN

Line 3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=

3711: qp_number.canonical_to_number(pb.pricing_attr_value_from)
3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3717:
3718: BEGIN
3719: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');

Line 3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));

3712: OR
3713: qp_number.canonical_to_number(pa.pricing_attr_value_from) <=
3714: qp_number.canonical_to_number(pb.pricing_attr_value_from) AND
3715: qp_number.canonical_to_number(pa.pricing_attr_value_to) >=
3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3717:
3718: BEGIN
3719: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');
3720: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);