DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on IBE_RETURN_DETAIL_V

Line 7631: FROM ibe_return_detail_v

7627: returned_quantity,
7628: lines_total,
7629: taxes_total,
7630: charges_total
7631: FROM ibe_return_detail_v
7632: WHERE header_id = p_order_id
7633: 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))
7634: ORDER BY line_number,
7635: shipment_number,

Line 7655: FROM ibe_return_detail_v

7651: returned_quantity,
7652: lines_total,
7653: taxes_total,
7654: charges_total
7655: FROM ibe_return_detail_v
7656: WHERE header_id = p_order_id
7657: and orig_link_to_line_id is not null and ( orig_top_model_line_id = to_number(p_mdl_source_line_id))
7658: ORDER BY line_number,
7659: shipment_number,

Line 7671: type order_details_tbl_type is table of ibe_return_detail_v%rowtype

7667: FROM ar_lookups
7668: WHERE lookup_type = 'CREDIT_MEMO_REASON'
7669: AND lookup_code = l_return_reason_code;
7670:
7671: type order_details_tbl_type is table of ibe_return_detail_v%rowtype
7672: INDEX BY BINARY_INTEGER;
7673: ord_detail_tbl order_details_tbl_type;
7674: i number :=1;
7675: j number :=1;