APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on ORG_FREIGHT

Line 1742: -- Validates ship_via_lookup_code against ORG_FREIGHTS.

1738: -- b) FND_MSG_PUB on unhandled exceptions.
1739: --Locks:
1740: -- None.
1741: --Function:
1742: -- Validates ship_via_lookup_code against ORG_FREIGHTS.
1743: --Parameters:
1744: --IN:
1745: --p_key
1746: -- Key used to access records in PO_SESSION_GT table.

Line 1787: -- SQL What: Bulk validate ship_via_lookup_code against ORG_FREIGHT.

1783: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.has_errors(1)='||p_headers_rec.has_errors(1)); END IF;
1784: END IF;
1785:
1786: l_progress := '020';
1787: -- SQL What: Bulk validate ship_via_lookup_code against ORG_FREIGHT.
1788: -- Get the errored rows into GT table.
1789: -- SQL Why : It will be used to mark the record in plsql table as error.
1790: -- SQL Join: ship_via_lookup_code
1791:

Line 1808: FROM ORG_FREIGHT OFR

1804: WHERE --p_headers_rec.has_errors(i) = 'N'
1805: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1806: AND p_headers_rec.freight_carrier(i) IS NOT NULL
1807: AND NOT EXISTS(SELECT 1
1808: FROM ORG_FREIGHT OFR
1809: WHERE p_headers_rec.freight_carrier(i) = OFR.freight_code
1810: AND NVL(OFR.disable_date, SYSDATE + 1) > SYSDATE
1811: AND OFR.organization_id = PO_R12_CAT_UPG_PVT.g_sys.inv_org_id);
1812: