DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMP_DETAILS_S

Line 1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL

1397: l_user_id NUMBER;
1398:
1399: BEGIN
1400:
1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1402: INTO l_item_comp_detail_id
1403: FROM DUAL;
1404:
1405: l_user_id := to_number(fnd_global.USER_ID);

Line 2134: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,

2130: ATTRIBUTE13 ,
2131: ATTRIBUTE14 ,
2132: ATTRIBUTE15 )
2133:
2134: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,
2135: l_item_composition_id ,
2136: item_group_id ,
2137: inventory_item_id ,
2138: inventory_master_org_id,

Line 2444: update ahl_item_comp_details set

2440: and effective_end_date is null;
2441:
2442:
2443: FORALL I IN 1..l_object_version_number.count
2444: update ahl_item_comp_details set
2445: uom_code =l_uom_code(I),
2446: quantity =l_quantity(I),
2447: last_update_date = sysdate,
2448: last_updated_by = to_number(fnd_global.user_id),