APPS.OE_HOLDS_PVT dependencies on RA_TERMS

Line 176: from ra_terms

172: WHERE payment_type_code = p_hold_entity_id;
173:
174: CURSOR payment_term_value_cur IS
175: select name
176: from ra_terms
177: WHERE term_id = p_hold_entity_id;
178:
179: CURSOR price_list_value_cur IS
180: select name

Line 2622: FROM ra_terms

2618: where inventory_item_id = p_hold_source_rec.hold_entity_id2;
2619: ELSIF p_hold_source_rec.hold_entity_code2 = 'PT' THEN
2620: SELECT 'Valid Entity'
2621: INTO l_dummy
2622: FROM ra_terms
2623: WHERE term_id = p_hold_source_rec.hold_entity_id2;
2624: ELSIF p_hold_source_rec.hold_entity_code2 = 'P' THEN
2625: SELECT 'Valid Entity'
2626: INTO l_dummy

Line 3505: ra_terms_b rt

3501: , ol.line_id
3502: , 'N'
3503: , l_org_id
3504: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
3505: ra_terms_b rt
3506: WHERE h.OPEN_FLAG = 'Y'
3507: and h.header_id = p_hold_source_rec.hold_entity_id2
3508: and h.header_id = ol.header_id
3509: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id

Line 3549: ra_terms_b rt

3545: , ol.line_id
3546: , 'N'
3547: , l_org_id
3548: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
3549: ra_terms_b rt
3550: WHERE h.OPEN_FLAG = 'Y'
3551: and h.header_id = p_hold_source_rec.hold_entity_id2
3552: and h.header_id = ol.header_id
3553: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id

Line 9442: ra_terms_b rt

9438: , ol.line_id
9439: , ''N''
9440: , h.org_id --ER#7479609 :l_org_id
9441: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
9442: ra_terms_b rt
9443: WHERE h.OPEN_FLAG = ''Y''
9444: and h.header_id = :hold_entity_id2
9445: and h.header_id = ol.header_id
9446: and h.org_id =:l_org_id --ER#7479609

Line 9514: ra_terms_b rt

9510: , ol.line_id
9511: , ''N''
9512: , h.org_id --ER#7479609 :l_org_id
9513: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
9514: ra_terms_b rt
9515: WHERE h.OPEN_FLAG = ''Y''
9516: and h.header_id = :hold_entity_id2
9517: and h.header_id = ol.header_id
9518: and h.org_id = :l_org_id --ER#7479609

Line 9574: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol , ra_terms_b rt

9570: RAISE FND_API.G_EXC_ERROR;
9571: ELSIF l_sql_rowcount > 0 THEN
9572: SELECT count(*)
9573: into l_parent_count
9574: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol , ra_terms_b rt
9575: WHERE h.OPEN_FLAG = 'Y'
9576: and h.header_id = p_hold_source_rec.hold_entity_id2
9577: and h.header_id = ol.header_id
9578: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id