DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on IBE_RETURN_DETAIL_V

Line 7536: FROM ibe_return_detail_v

7532: returned_quantity,
7533: lines_total,
7534: taxes_total,
7535: charges_total
7536: FROM ibe_return_detail_v
7537: WHERE header_id = p_order_id
7538: AND (orig_top_model_line_id is null or (orig_top_model_line_id = source_line_id and orig_link_to_line_id is null))
7539: ORDER BY line_number,
7540: shipment_number,

Line 7560: FROM ibe_return_detail_v

7556: returned_quantity,
7557: lines_total,
7558: taxes_total,
7559: charges_total
7560: FROM ibe_return_detail_v
7561: WHERE header_id = p_order_id
7562: and orig_link_to_line_id is not null and ( orig_top_model_line_id = to_number(p_mdl_source_line_id))
7563: ORDER BY line_number,
7564: shipment_number,

Line 7576: type order_details_tbl_type is table of ibe_return_detail_v%rowtype

7572: FROM ar_lookups
7573: WHERE lookup_type = 'CREDIT_MEMO_REASON'
7574: AND lookup_code = l_return_reason_code;
7575:
7576: type order_details_tbl_type is table of ibe_return_detail_v%rowtype
7577: INDEX BY BINARY_INTEGER;
7578: ord_detail_tbl order_details_tbl_type;
7579: i number :=1;
7580: j number :=1;