APPS.OE_HOLDS_PVT dependencies on RA_TERMS

Line 122: from ra_terms

118: WHERE payment_type_code = p_hold_entity_id;
119:
120: CURSOR payment_term_value_cur IS
121: select name
122: from ra_terms
123: WHERE term_id = p_hold_entity_id;
124:
125: CURSOR price_list_value_cur IS
126: select name

Line 2167: FROM ra_terms

2163: where inventory_item_id = p_hold_source_rec.hold_entity_id2;
2164: ELSIF p_hold_source_rec.hold_entity_code2 = 'PT' THEN
2165: SELECT 'Valid Entity'
2166: INTO l_dummy
2167: FROM ra_terms
2168: WHERE term_id = p_hold_source_rec.hold_entity_id2;
2169: ELSIF p_hold_source_rec.hold_entity_code2 = 'P' THEN
2170: SELECT 'Valid Entity'
2171: INTO l_dummy

Line 3050: ra_terms_b rt

3046: , ol.line_id
3047: , 'N'
3048: , l_org_id
3049: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
3050: ra_terms_b rt
3051: WHERE h.OPEN_FLAG = 'Y'
3052: and h.header_id = p_hold_source_rec.hold_entity_id2
3053: and h.header_id = ol.header_id
3054: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id

Line 3094: ra_terms_b rt

3090: , ol.line_id
3091: , 'N'
3092: , l_org_id
3093: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
3094: ra_terms_b rt
3095: WHERE h.OPEN_FLAG = 'Y'
3096: and h.header_id = p_hold_source_rec.hold_entity_id2
3097: and h.header_id = ol.header_id
3098: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id

Line 8578: ra_terms_b rt

8574: , ol.line_id
8575: , ''N''
8576: , h.org_id --ER#7479609 :l_org_id
8577: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
8578: ra_terms_b rt
8579: WHERE h.OPEN_FLAG = ''Y''
8580: and h.header_id = :hold_entity_id2
8581: and h.header_id = ol.header_id
8582: and h.org_id =:l_org_id --ER#7479609

Line 8650: ra_terms_b rt

8646: , ol.line_id
8647: , ''N''
8648: , h.org_id --ER#7479609 :l_org_id
8649: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol,
8650: ra_terms_b rt
8651: WHERE h.OPEN_FLAG = ''Y''
8652: and h.header_id = :hold_entity_id2
8653: and h.header_id = ol.header_id
8654: and h.org_id = :l_org_id --ER#7479609

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

8706: RAISE FND_API.G_EXC_ERROR;
8707: ELSIF l_sql_rowcount > 0 THEN
8708: SELECT count(*)
8709: into l_parent_count
8710: FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL ol , ra_terms_b rt
8711: WHERE h.OPEN_FLAG = 'Y'
8712: and h.header_id = p_hold_source_rec.hold_entity_id2
8713: and h.header_id = ol.header_id
8714: and ol.INVOICE_TO_ORG_ID = p_hold_source_rec.hold_entity_id