DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on CSP_REQUIREMENT_HEADERS

Line 1202: csp_requirement_headers crh

1198: crh.ship_to_location_id,
1199: decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id),
1200: decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
1201: from jtf_task_assignments jta,
1202: csp_requirement_headers crh
1203: where jta.task_assignment_id(+) = crh.task_assignment_id
1204: and crh.requirement_header_id = p_rqmt_header_id;
1205:
1206: CURSOR get_new_context(p_new_org_id number) IS

Line 1222: csp_requirement_headers_v req

1218: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1219: HZ_CUST_SITE_USES_ALL site_use,
1220: hz_party_site_uses hpsu,
1221: cs_incidents_all cia,
1222: csp_requirement_headers_v req
1223: WHERE req.requirement_header_id = p_rqmt_header_id
1224: and cia.incident_id = req.incident_id
1225: and cust_acct.cust_account_id = cia.bill_to_account_id
1226: and hpsu.party_site_use_id = cia.bill_to_site_use_id