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_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 219: FROM AHL_ITEM_COMP_DETAILS

215: CURSOR item_group_exists(p_item_group_id IN NUMBER,
216: p_item_composition_id IN NUMBER)
217: IS
218: SELECT 'x'
219: FROM AHL_ITEM_COMP_DETAILS
220: WHERE ITEM_GROUP_ID = p_item_group_id
221: AND ITEM_COMPOSITION_ID= p_item_composition_id
222: AND EFFECTIVE_END_DATE is null;
223:

Line 229: FROM AHL_ITEM_COMP_DETAILS

225: p_inventory_master_org_id IN NUMBER,
226: p_item_composition_id IN NUMBER)
227: IS
228: SELECT 'x'
229: FROM AHL_ITEM_COMP_DETAILS
230: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
231: AND INVENTORY_MASTER_ORG_ID = p_inventory_master_org_id
232: AND ITEM_COMPOSITION_ID= p_item_composition_id
233: AND EFFECTIVE_END_DATE is null;

Line 240: FROM AHL_ITEM_COMP_DETAILS

236: CURSOR get_item_comp_det( p_item_composition_id IN NUMBER,
237: p_item_comp_detail_id IN NUMBER)
238: IS
239: SELECT 'x'
240: FROM AHL_ITEM_COMP_DETAILS
241: WHERE item_comp_detail_id = p_item_comp_detail_id
242: AND item_composition_id= p_item_composition_id;
243:
244:

Line 1109: DELETE FROM AHL_ITEM_COMP_DETAILS

1105:
1106: ELSIF l_item_composition_rec.approval_status_code IN ('DRAFT','APPROVAL_REJECTED') THEN
1107:
1108:
1109: DELETE FROM AHL_ITEM_COMP_DETAILS
1110: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1111:
1112: DELETE FROM AHL_ITEM_COMPOSITIONS
1113: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;

Line 1417: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL

1413: l_user_id NUMBER;
1414:
1415: BEGIN
1416:
1417: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1418: INTO l_item_comp_detail_id
1419: FROM DUAL;
1420:
1421: l_user_id := to_number(fnd_global.USER_ID);

Line 1425: INSERT INTO AHL_ITEM_COMP_DETAILS(

1421: l_user_id := to_number(fnd_global.USER_ID);
1422:
1423: IF p_item_composition_id IS NOT NULL THEN
1424:
1425: INSERT INTO AHL_ITEM_COMP_DETAILS(
1426: ITEM_COMP_DETAIL_ID ,
1427: ITEM_COMPOSITION_ID ,
1428: ITEM_GROUP_ID ,
1429: INVENTORY_ITEM_ID ,

Line 1516: UPDATE AHL_ITEM_COMP_DETAILS

1512: AS
1513:
1514: BEGIN
1515:
1516: UPDATE AHL_ITEM_COMP_DETAILS
1517: SET
1518: ITEM_GROUP_ID =p_x_comp_det_rec.ITEM_GROUP_ID,
1519: INVENTORY_ITEM_ID =p_x_comp_det_rec.INVENTORY_ITEM_ID,
1520: INVENTORY_MASTER_ORG_ID = p_x_comp_det_rec.INVENTORY_MASTER_ORG_ID,

Line 1561: DELETE FROM AHL_ITEM_COMP_DETAILS

1557: AS
1558:
1559: BEGIN
1560:
1561: DELETE FROM AHL_ITEM_COMP_DETAILS
1562: WHERE ITEM_COMP_DETAIL_ID = p_x_comp_det_rec.item_comp_detail_id
1563: AND ITEM_COMPOSITION_ID = p_item_composition_id;
1564:
1565:

Line 1687: from ahl_item_comp_details

1683: x_msg_data =>l_msg_data);
1684:
1685: Select count(*)
1686: into l_count
1687: from ahl_item_comp_details
1688: where item_composition_id = p_Item_Composition_id;
1689:
1690:
1691: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

Line 1710: from ahl_item_comp_details

1706:
1707:
1708: select count(*)
1709: into l_count
1710: from ahl_item_comp_details
1711: where item_composition_id = p_Item_Composition_id;
1712:
1713: IF l_count < 1 THEN
1714: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');

Line 2116: INSERT INTO AHL_ITEM_COMP_DETAILS(

2112:
2113:
2114: IF p_Item_comp_id IS NOT NULL THEN
2115:
2116: INSERT INTO AHL_ITEM_COMP_DETAILS(
2117: ITEM_COMP_DETAIL_ID ,
2118: ITEM_COMPOSITION_ID ,
2119: ITEM_GROUP_ID ,
2120: INVENTORY_ITEM_ID ,

Line 2150: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,

2146: ATTRIBUTE13 ,
2147: ATTRIBUTE14 ,
2148: ATTRIBUTE15 )
2149:
2150: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,
2151: l_item_composition_id ,
2152: item_group_id ,
2153: inventory_item_id ,
2154: inventory_master_org_id,

Line 2182: FROM ahl_item_comp_details

2178: attribute12 ,
2179: attribute13 ,
2180: attribute14 ,
2181: attribute15
2182: FROM ahl_item_comp_details
2183: WHERE item_composition_id = p_Item_comp_id
2184: AND effective_end_date is null;
2185:
2186: END IF;

Line 2532: from ahl_item_comp_details

2528: l_attribute14 ,
2529: l_attribute15
2530: -- manisaga added these attributes for DFF implementation om 22-Feb-2010 -- End
2531:
2532: from ahl_item_comp_details
2533: where item_composition_id = l_item_comp_det.item_composition_id
2534: and link_comp_detl_id is not null
2535: and effective_end_date is null;
2536:

Line 2539: update ahl_item_comp_details set

2535: and effective_end_date is null;
2536:
2537:
2538: FORALL I IN 1..l_object_version_number.count
2539: update ahl_item_comp_details set
2540: uom_code =l_uom_code(I),
2541: quantity =l_quantity(I),
2542: last_update_date = sysdate,
2543: last_updated_by = to_number(fnd_global.user_id),

Line 2573: Update ahl_item_comp_details

2569: and NVL(inventory_master_org_id,-3)= NVL(l_inventory_master_org_id(I),-3)
2570: and effective_end_date is null;
2571:
2572:
2573: Update ahl_item_comp_details
2574: Set effective_end_date = sysdate-1,
2575: last_update_date =sysdate,
2576: last_updated_by = to_number(fnd_global.user_id),
2577: last_update_login = to_number(fnd_global.login_id),

Line 2583: from ahl_item_comp_details

2579: Where item_composition_id=l_item_comp_det.link_comp_id
2580: and effective_end_date is null
2581: and ITEM_COMP_DETAIL_ID not in (
2582: Select link_comp_detl_id
2583: from ahl_item_comp_details
2584: where item_composition_id = l_item_comp_det.item_composition_id
2585: and link_comp_detl_id is not null);
2586:
2587:

Line 2588: Update ahl_item_comp_details

2584: where item_composition_id = l_item_comp_det.item_composition_id
2585: and link_comp_detl_id is not null);
2586:
2587:
2588: Update ahl_item_comp_details
2589: Set item_composition_id = l_item_comp_det.link_comp_id,
2590: last_update_date =sysdate,
2591: last_updated_by = to_number(fnd_global.user_id),
2592: last_update_login = to_number(fnd_global.login_id),

Line 2624: Delete from ahl_item_comp_details

2620: -- manisaga added attributes for DFF implementation on 22-Feb-2010 -- End
2621:
2622: Where item_composition_id=l_item_comp_det.link_comp_id;
2623:
2624: Delete from ahl_item_comp_details
2625: where item_composition_id = l_item_comp_det.item_composition_id;
2626:
2627: Delete from ahl_item_compositions
2628: Where item_composition_id=l_item_comp_det.item_composition_id;