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.PN_RECOVERY_EXTRACT_PKG dependencies on PN_LOCATIONS_ALL

Line 951: FROM pn_locations_all

947: property_id,
948: active_start_date,
949: active_end_date,
950: assignable_area
951: FROM pn_locations_all
952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN

Line 956: (SELECT location_id FROM pn_locations_all

952: WHERE location_type_lookup_code IN ('SECTION','OFFICE')
953: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
954: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
955: AND location_id IN
956: (SELECT location_id FROM pn_locations_all
957: START WITH (location_id = p_location_id OR
958: (property_id = p_property_id AND p_location_id IS NULL))
959: CONNECT BY PRIOR location_id = parent_location_id)
960: ORDER BY location_id;

Line 978: FROM pn_locations_all

974: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date);
975:
976: CURSOR get_uom_info_from_prop(p_property_id pn_locations.property_id%TYPE) IS
977: SELECT uom_code
978: FROM pn_locations_all
979: WHERE property_id = p_property_id
980: AND active_start_date < fnd_date.canonical_to_date(p_to_date)
981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:

Line 985: FROM pn_locations_all

981: AND active_end_date > fnd_date.canonical_to_date(p_from_date);
982:
983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all
986: WHERE location_id IN
987: (SELECT location_id FROM pn_locations_all
988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)

Line 987: (SELECT location_id FROM pn_locations_all

983: CURSOR get_uom_info_from_locn(p_location_id pn_locations.location_id%TYPE) IS
984: SELECT uom_code
985: FROM pn_locations_all
986: WHERE location_id IN
987: (SELECT location_id FROM pn_locations_all
988: START WITH location_id = p_location_id
989: CONNECT BY location_id = PRIOR parent_location_id)
990: AND parent_location_id IS NULL
991: AND active_start_date < fnd_date.canonical_to_date(p_to_date)

Line 1086: l_uom_code pn_locations_all.uom_code%TYPE;

1082: l_area_total_tbl area_cls_line_hdr_tbl;
1083: l_arcl_locid pn_rec_arcl.location_id%TYPE;
1084: l_arcl_propid pn_rec_arcl.property_id%TYPE;
1085: l_arcl_exc_table area_cls_exc_tbl;
1086: l_uom_code pn_locations_all.uom_code%TYPE;
1087: l_info VARCHAR2(100);
1088: l_desc VARCHAR2(100) := 'pn_recovery_extract_pkg.extract_area' ;
1089:
1090:

Line 1675: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;

1671: IS
1672: l_result BOOLEAN:= FALSE;
1673:
1674: CURSOR loc_check IS
1675: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1676:
1677: CURSOR prop_check IS
1678: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1679:

Line 1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */

1678: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1679:
1680: /* Commented and modified for Bug 6461211
1681: CURSOR prop_loc_combo_check IS
1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1683:
1684: CURSOR prop_loc_combo_check IS
1685: SELECT 'TRUE' FROM pn_locations_all
1686: WHERE property_id = p_property_id

Line 1685: SELECT 'TRUE' FROM pn_locations_all

1681: CURSOR prop_loc_combo_check IS
1682: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1683:
1684: CURSOR prop_loc_combo_check IS
1685: SELECT 'TRUE' FROM pn_locations_all
1686: WHERE property_id = p_property_id
1687: START WITH location_id = p_location_id
1688: CONNECT BY PRIOR parent_location_id = location_id;
1689:

Line 2060: (SELECT location_id FROM pn_locations_all

2056: AND from_date = p_from_date
2057: AND to_date = p_to_date
2058: AND currency_code = p_currency_code
2059: AND (location_id IN
2060: (SELECT location_id FROM pn_locations_all
2061: WHERE active_start_date < p_to_date
2062: AND active_end_date > p_from_date
2063: START WITH (location_id = p_location_id OR
2064: (property_id = p_property_id AND p_location_id IS NULL))

Line 2819: FROM pn_locations_all

2815:
2816: CURSOR get_locn_prop_id IS
2817: SELECT property_id,
2818: location_id
2819: FROM pn_locations_all
2820: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2821: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2822: START WITH location_id = p_location_id
2823: CONNECT BY location_id = PRIOR parent_location_id;

Line 2965: FROM pn_locations_all

2961:
2962: CURSOR get_locn_prop_id IS
2963: SELECT property_id,
2964: location_id
2965: FROM pn_locations_all
2966: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2967: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2968: START WITH location_id = p_location_id
2969: CONNECT BY location_id = PRIOR parent_location_id;

Line 3255: (SELECT location_id FROM pn_locations_all locn

3251: cust.recovery_space_std_code,
3252: cust.recovery_type_code
3253: FROM pn_space_assign_cust_all cust
3254: WHERE cust.location_id IN
3255: (SELECT location_id FROM pn_locations_all locn
3256: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3257: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3258: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)

Line 3263: (SELECT location_id FROM pn_locations_all

3259: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3260: AND cust.recovery_space_std_code = p_rec_spc_std_code
3261: AND cust.recovery_type_code = p_rec_type_code
3262: AND cust.location_id IN
3263: (SELECT location_id FROM pn_locations_all
3264: START WITH (location_id = p_location_id OR
3265: (property_id = p_property_id AND p_location_id IS NULL))
3266: CONNECT BY PRIOR location_id = parent_location_id);
3267: