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.INV_LABEL_PVT10 dependencies on AR_LOOKUPS

Line 1021: ar_lookups.meaning tax_exempt_reason,

1017: ras.name salesreps_name,
1018: to_char(oline.schedule_arrival_date, G_DATE_FORMAT_MASK),
1019: oe_sets.set_name ship_set_name,
1020: osmv.meaning shipping_method_name,
1021: ar_lookups.meaning tax_exempt_reason,
1022: oline.tax_code,
1023: oline.tax_exempt_flag,
1024: oline.tax_exempt_number,
1025: oline.tax_rate,

Line 1177: AR_LOOKUPS,

1173: PA_PROJECTS pp,
1174: --ORG_FREIGHT_VL ofv,
1175: RA_SALESREPS ras,
1176: OE_SETS,
1177: AR_LOOKUPS,
1178: MTL_PARAMETERS ship_from_org
1179: WHERE oline.line_id = p_line_id
1180: AND oline.sold_to_org_id = oline_rc.customer_id(+)
1181: AND oline.deliver_to_contact_id = dcontact.contact_id(+)

Line 1189: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)

1185: AND oline.salesrep_id = ras.salesrep_id(+)
1186: AND oline.ship_set_id = oe_sets.set_id(+)
1187: AND oline.ship_to_contact_id = rcship.contact_id(+)
1188: AND oline.shipping_method_code = osmv.lookup_code(+)
1189: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)
1190: and ar_lookups.lookup_type(+) = 'TAX_REASON'
1191: AND oline.project_id =pp.project_id(+)
1192: AND oline.ship_from_org_id = ship_from_org.organization_id(+);
1193: --AND oline.freight_carrier_code = ofv.freight_code(+)

Line 1190: and ar_lookups.lookup_type(+) = 'TAX_REASON'

1186: AND oline.ship_set_id = oe_sets.set_id(+)
1187: AND oline.ship_to_contact_id = rcship.contact_id(+)
1188: AND oline.shipping_method_code = osmv.lookup_code(+)
1189: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)
1190: and ar_lookups.lookup_type(+) = 'TAX_REASON'
1191: AND oline.project_id =pp.project_id(+)
1192: AND oline.ship_from_org_id = ship_from_org.organization_id(+);
1193: --AND oline.freight_carrier_code = ofv.freight_code(+)
1194:

Line 1581: ar_lookups.meaning tax_exempt_reason,

1577: ras.name salesreps_name,
1578: to_char(oline.schedule_arrival_date, G_DATE_FORMAT_MASK),
1579: oe_sets.set_name ship_set_name,
1580: osmv.meaning shipping_method_name,
1581: ar_lookups.meaning tax_exempt_reason,
1582: oline.tax_code,
1583: oline.tax_exempt_flag,
1584: oline.tax_exempt_number,
1585: oline.tax_rate,

Line 1691: AR_LOOKUPS,

1687: PA_PROJECTS pp,
1688: --ORG_FREIGHT_VL ofv,
1689: RA_SALESREPS ras,
1690: OE_SETS,
1691: AR_LOOKUPS,
1692: MTL_PARAMETERS ship_from_org
1693: WHERE oline.line_id = p_line_id
1694: AND oline.deliver_to_contact_id = dcontact.contact_id(+)
1695: AND oline.intmed_ship_to_contact_id = isc.contact_id(+)

Line 1700: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)

1696: AND oline.salesrep_id = ras.salesrep_id(+)
1697: AND oline.ship_set_id = oe_sets.set_id(+)
1698: AND oline.ship_to_contact_id = rcship.contact_id(+)
1699: AND oline.shipping_method_code = osmv.lookup_code(+)
1700: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)
1701: and ar_lookups.lookup_type(+) = 'TAX_REASON'
1702: AND oline.invoice_to_contact_id = invc.contact_id(+)
1703: AND oline.project_id =pp.project_id(+)
1704: AND oline.ship_from_org_id = ship_from_org.organization_id(+);

Line 1701: and ar_lookups.lookup_type(+) = 'TAX_REASON'

1697: AND oline.ship_set_id = oe_sets.set_id(+)
1698: AND oline.ship_to_contact_id = rcship.contact_id(+)
1699: AND oline.shipping_method_code = osmv.lookup_code(+)
1700: AND oline.tax_exempt_reason_code = ar_lookups.lookup_code(+)
1701: and ar_lookups.lookup_type(+) = 'TAX_REASON'
1702: AND oline.invoice_to_contact_id = invc.contact_id(+)
1703: AND oline.project_id =pp.project_id(+)
1704: AND oline.ship_from_org_id = ship_from_org.organization_id(+);
1705: --AND oline.freight_carrier_code = ofv.freight_code(+)