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.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on HZ_PARTY_SITES

Line 473: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN

469: p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
470: , p_organization_id => l_org_id
471: , p_resource_id => p_resource_id );
472:
473: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN
474: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE(
475: p_party_site_id => r_ii.LOCATION_ID
476: ,p_resource_id => p_resource_id);
477:

Line 474: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE(

470: , p_organization_id => l_org_id
471: , p_resource_id => p_resource_id );
472:
473: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN
474: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE(
475: p_party_site_id => r_ii.LOCATION_ID
476: ,p_resource_id => p_resource_id);
477:
478: ELSIF r_ii.location_type_code = 'HZ_LOCATIONS' THEN

Line 612: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN

608: ( p_inventory_item_id => r_ii.INVENTORY_ITEM_ID
609: , p_organization_id => l_org_id
610: , p_resource_id => p_resource_id
611: );
612: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN
613: CSL_HZ_PARTY_SITES_ACC_PKG.DELETE_PARTY_SITE
614: ( p_party_site_id => r_ii.LOCATION_ID
615: ,p_resource_id => p_resource_id);
616: ELSIF r_ii.location_type_code = 'HZ_LOCATIONS' THEN

Line 613: CSL_HZ_PARTY_SITES_ACC_PKG.DELETE_PARTY_SITE

609: , p_organization_id => l_org_id
610: , p_resource_id => p_resource_id
611: );
612: IF r_ii.location_type_code = 'HZ_PARTY_SITES' THEN
613: CSL_HZ_PARTY_SITES_ACC_PKG.DELETE_PARTY_SITE
614: ( p_party_site_id => r_ii.LOCATION_ID
615: ,p_resource_id => p_resource_id);
616: ELSIF r_ii.location_type_code = 'HZ_LOCATIONS' THEN
617: CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION

Line 800: SELECT party_id, location_id FROM hz_party_sites

796:
797: /** ER 3168446 - View IB at Location Fix */
798:
799: CURSOR c_ib_party ( b_party_site_id NUMBER ) IS
800: SELECT party_id, location_id FROM hz_party_sites
801: WHERE party_site_id = b_party_site_id;
802:
803:
804: CURSOR c_existing_ib_at_location (

Line 817: AND cii.location_type_code = 'HZ_PARTY_SITES'

813: WHERE acc.instance_id = cii.instance_id
814: AND acc.resource_id = b_resource_id
815: AND owner_party_id = b_party_id
816: AND ( ( cii.location_id = b_party_site_id
817: AND cii.location_type_code = 'HZ_PARTY_SITES'
818: ) OR
819: ( cii.location_id = b_location_id
820: AND cii.location_type_code = 'HZ_LOCATIONS'
821: )

Line 857: AND cii.location_type_code = 'HZ_PARTY_SITES'

853: WHERE acc.resource_id = b_resource_id
854: )
855: AND owner_party_id = b_party_id
856: AND ( ( cii.location_id = b_party_site_id
857: AND cii.location_type_code = 'HZ_PARTY_SITES'
858: ) OR
859: ( cii.location_id = b_location_id
860: AND cii.location_type_code = 'HZ_LOCATIONS'
861: )

Line 1085: SELECT party_id, location_id FROM hz_party_sites

1081:
1082: /** ER 3168446 - View IB at location Fix */
1083:
1084: CURSOR c_ib_party ( b_party_site_id NUMBER ) IS
1085: SELECT party_id, location_id FROM hz_party_sites
1086: WHERE party_site_id = b_party_site_id;
1087:
1088:
1089: CURSOR c_ib_at_location (

Line 1100: AND cii.location_type_code = 'HZ_PARTY_SITES' )

1096: WHERE acc.instance_id = cii.instance_id
1097: AND acc.resource_id = b_resource_id
1098: AND owner_party_id = b_party_id
1099: AND ( ( cii.location_id = b_party_site_id
1100: AND cii.location_type_code = 'HZ_PARTY_SITES' )
1101: OR ( cii.location_id = b_location_id
1102: AND cii.location_type_code = 'HZ_LOCATIONS') );
1103:
1104: l_party_id NUMBER;