DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMP_DETAILS_S

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 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 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),