APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_PRD_MB_UC_DETAILS

Line 1488: INSERT INTO ahl_prd_mb_uc_details

1484: END IF;
1485:
1486: IF x_mrshl_details_tbl.FIRST IS NOT NULL THEN
1487: FOR i IN x_mrshl_details_tbl.FIRST..x_mrshl_details_tbl.LAST LOOP
1488: INSERT INTO ahl_prd_mb_uc_details
1489: (
1490: Unit_Header_id,
1491: Unit_Name,
1492: --Path_position_id,

Line 1629: Select * FROM ahl_prd_mb_uc_details

1625: AND C.inventory_item_id = M.inventory_item_id
1626: AND C.inv_master_organization_id = M.organization_id;
1627:
1628: /*CURSOR get_all_details(c_unit_header_id IN NUMBER) IS
1629: Select * FROM ahl_prd_mb_uc_details
1630: WHERE UNIT_HEADER_ID = c_unit_header_id;*/
1631:
1632: CURSOR get_pos_dtls_csr(c_mc_relationship_id IN NUMBER,
1633: c_instance_id IN NUMBER) IS