APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_MTL_ITEMS_NON_OU_V

Line 325: FROM ahl_mtl_items_non_ou_v

321: CURSOR mtl_system_items_csr(p_inventory_item_id IN NUMBER,
322: p_inventory_org_id IN NUMBER) IS
323: SELECT NVL(comms_nl_trackable_flag,'N'), concatenated_segments,
324: SERIAL_NBR_CNTRL_CODE,revision_qty_cntrl_code
325: FROM ahl_mtl_items_non_ou_v
326: WHERE inventory_item_id = p_inventory_item_id
327: AND inventory_org_id = p_inventory_org_id;
328:
329: CURSOR mtl_system_items_non_ou_csr(p_inventory_item_id IN NUMBER,

Line 333: FROM ahl_mtl_items_non_ou_v

329: CURSOR mtl_system_items_non_ou_csr(p_inventory_item_id IN NUMBER,
330: p_inventory_org_id IN NUMBER) IS
331: SELECT NVL(comms_nl_trackable_flag,'N'), concatenated_segments,
332: SERIAL_NBR_CNTRL_CODE,revision_qty_cntrl_code
333: FROM ahl_mtl_items_non_ou_v
334: WHERE inventory_item_id = p_inventory_item_id
335: AND inventory_org_id = p_inventory_org_id;
336:
337: CURSOR mtl_parameters_csr(p_inventory_org_id IN NUMBER) IS

Line 344: l_segment1 ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

340: FROM mtl_parameters
341: WHERE organization_id = p_inventory_org_id;
342:
343: l_instance_track VARCHAR2(1);
344: l_segment1 ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
345: l_serial_number_control NUMBER;
346: l_revision_qty_control_code NUMBER;
347: l_organization_code mtl_parameters.organization_code%TYPE;
348:

Line 897: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

893: FROM AHL_ITEM_ASSOCIATIONS_V
894: WHERE item_association_id = p_item_assoc_id;
895:
896: l_item_assoc_rec Item_assoc_csr%ROWTYPE;
897: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
898: l_x_item_assoc_rec AHL_MC_ITEMGROUP_PVT.Item_Association_Rec_Type DEFAULT p_item_assoc_rec;
899:
900: l_revision_qty_control_code NUMBER;
901: l_serial_number_control NUMBER;

Line 1751: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

1747: l_inventory_list G_ITEM_DTL_TYPE;
1748: l_inventory_item_id NUMBER;
1749: l_item_group_id NUMBER; -- sequence generated item group id.
1750: l_name ahl_item_groups_b.name%TYPE;
1751: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
1752: l_row_id VARCHAR2(30);
1753:
1754: BEGIN
1755: -- Standard start of API savepoint