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 953: FROM pn_locations_all

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

Line 958: (SELECT location_id FROM pn_locations_all

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

Line 980: FROM pn_locations_all

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

Line 987: FROM pn_locations_all

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

Line 989: (SELECT location_id FROM pn_locations_all

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

Line 1088: l_uom_code pn_locations_all.uom_code%TYPE;

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

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

1683: IS
1684: l_result BOOLEAN:= FALSE;
1685:
1686: CURSOR loc_check IS
1687: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id;
1688:
1689: CURSOR prop_check IS
1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1691:

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

1690: SELECT 'TRUE' FROM pn_properties_all WHERE property_id = p_property_id;
1691:
1692: /* Commented and modified for Bug 6461211
1693: CURSOR prop_loc_combo_check IS
1694: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1695:
1696: CURSOR prop_loc_combo_check IS
1697: SELECT 'TRUE' FROM pn_locations_all
1698: WHERE property_id = p_property_id

Line 1697: SELECT 'TRUE' FROM pn_locations_all

1693: CURSOR prop_loc_combo_check IS
1694: SELECT 'TRUE' FROM pn_locations_all WHERE location_id = p_location_id AND property_id = p_property_id; */
1695:
1696: CURSOR prop_loc_combo_check IS
1697: SELECT 'TRUE' FROM pn_locations_all
1698: WHERE property_id = p_property_id
1699: START WITH location_id = p_location_id
1700: CONNECT BY PRIOR parent_location_id = location_id;
1701:

Line 2072: (SELECT location_id FROM pn_locations_all

2068: AND from_date = p_from_date
2069: AND to_date = p_to_date
2070: AND currency_code = p_currency_code
2071: AND (location_id IN
2072: (SELECT location_id FROM pn_locations_all
2073: WHERE active_start_date < p_to_date
2074: AND active_end_date > p_from_date
2075: START WITH (location_id = p_location_id OR
2076: (property_id = p_property_id AND p_location_id IS NULL))

Line 2831: FROM pn_locations_all

2827:
2828: CURSOR get_locn_prop_id IS
2829: SELECT property_id,
2830: location_id
2831: FROM pn_locations_all
2832: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2833: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2834: START WITH location_id = p_location_id
2835: CONNECT BY location_id = PRIOR parent_location_id;

Line 2977: FROM pn_locations_all

2973:
2974: CURSOR get_locn_prop_id IS
2975: SELECT property_id,
2976: location_id
2977: FROM pn_locations_all
2978: WHERE active_start_date < fnd_date.canonical_to_date(p_to_date)
2979: AND active_end_date > fnd_date.canonical_to_date(p_from_date)
2980: START WITH location_id = p_location_id
2981: CONNECT BY location_id = PRIOR parent_location_id;

Line 3267: (SELECT location_id FROM pn_locations_all locn

3263: cust.recovery_space_std_code,
3264: cust.recovery_type_code
3265: FROM pn_space_assign_cust_all cust
3266: WHERE cust.location_id IN
3267: (SELECT location_id FROM pn_locations_all locn
3268: WHERE locn.active_start_date < fnd_date.canonical_to_date(p_to_date)
3269: AND locn.active_end_date > fnd_date.canonical_to_date(p_from_date))
3270: AND cust.cust_assign_start_date < fnd_date.canonical_to_date(p_to_date)
3271: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)

Line 3275: (SELECT location_id FROM pn_locations_all

3271: AND cust.fin_oblig_end_date > fnd_date.canonical_to_date(p_from_date)
3272: AND cust.recovery_space_std_code = p_rec_spc_std_code
3273: AND cust.recovery_type_code = p_rec_type_code
3274: AND cust.location_id IN
3275: (SELECT location_id FROM pn_locations_all
3276: START WITH (location_id = p_location_id OR
3277: (property_id = p_property_id AND p_location_id IS NULL))
3278: CONNECT BY PRIOR location_id = parent_location_id);
3279: