DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on GMD_TECHNICAL_DATA_HDR

Line 243: FROM gmd_technical_data_hdr

239: AND (organization_id = l_orgn_id OR organization_id IS NULL);
240:
241: CURSOR get_Orgn_id IS
242: SELECT organization_id
243: FROM gmd_technical_data_hdr
244: WHERE tech_data_id = p_tech_data_id;
245:
246: CURSOR get_row_count (l_tech_parm_id NUMBER)IS
247: SELECT COUNT(1)

Line 575: FROM gmd_technical_data_hdr

571: ) IS
572:
573: CURSOR c_get_recs IS
574: SELECT count(*)
575: FROM gmd_technical_data_hdr
576: WHERE organization_id = p_header_rec.organization_id
577: AND inventory_item_id = p_header_rec.inventory_item_id
578: AND NVL(lot_number, -1) = nvl(p_header_rec.lot_number, -1) /* Added NVL in bug No.6051738 */
579: AND NVL(lot_organization_id,-1) = nvl(p_header_rec.lot_organization_id, -1) /* Added this condition in bug No.6051738 */