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.AHL_UC_INSTANCE_PVT dependencies on AHL_ITEM_ASSOCIATIONS_TL

Line 2283: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;

2279: l_parent_uc_header_id NUMBER;
2280: l_parent_instance_id NUMBER;
2281: l_position_ref_meaning fnd_lookups.meaning%TYPE;
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
2284:
2285: --Variables needed for CSI API call
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;

Line 2401: -- SATHAPLI::ER 7419780, 24-Aug-2009, fetch the INTERCHANGE_REASON from the table ahl_item_associations_tl too

2397: WHERE relationship_id = c_relationship_id
2398: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
2399: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2400:
2401: -- SATHAPLI::ER 7419780, 24-Aug-2009, fetch the INTERCHANGE_REASON from the table ahl_item_associations_tl too
2402: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
2403: SELECT i.interchange_type_code,
2404: itl.interchange_reason
2405: FROM csi_item_instances c,

Line 2407: ahl_item_associations_tl itl,

2403: SELECT i.interchange_type_code,
2404: itl.interchange_reason
2405: FROM csi_item_instances c,
2406: ahl_item_associations_b i,
2407: ahl_item_associations_tl itl,
2408: ahl_mc_relationships m
2409: WHERE m.relationship_id = c_relationship_id
2410: AND c.instance_id = c_instance_id
2411: AND m.item_group_id = i.item_group_id

Line 3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;

3350: l_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3351: l_active_uc_status_code FND_LOOKUP_VALUES.lookup_code%TYPE;
3352: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3353: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
3355:
3356: --Variables needed for CSI API call
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;

Line 3602: -- SATHAPLI::ER 7419780, 24-Aug-2009, fetch the INTERCHANGE_REASON from the table ahl_item_associations_tl too

3598: AND relationship_type_code = 'COMPONENT-OF'
3599: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
3600: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3601:
3602: -- SATHAPLI::ER 7419780, 24-Aug-2009, fetch the INTERCHANGE_REASON from the table ahl_item_associations_tl too
3603: CURSOR get_interchange_type (c_instance_id NUMBER, c_relationship_id NUMBER) IS
3604: SELECT i.interchange_type_code,
3605: itl.interchange_reason
3606: FROM csi_item_instances c,

Line 3608: ahl_item_associations_tl itl,

3604: SELECT i.interchange_type_code,
3605: itl.interchange_reason
3606: FROM csi_item_instances c,
3607: ahl_item_associations_b i,
3608: ahl_item_associations_tl itl,
3609: ahl_mc_relationships m
3610: WHERE m.relationship_id = c_relationship_id
3611: AND c.instance_id = c_instance_id
3612: AND m.item_group_id = i.item_group_id