Attachment 2012 Details for Bug 6078 – SS_0905_IMIS_Against call id - 6078

SS_0905_IMIS_Against call id - 6078

SS_0905_IMIS_Against call id - 6078.sql (text/plain), 2.09 KB, created by Sharad on 2021-07-02 15:38:02 IST

(hide)

Description:

Filename:

MIME Type:

Creator: Sharad

Created: 2021-07-02 15:38:02 IST

Size: 2.09 KB

patch

obsolete

>CREATE OR REPLACE VIEW VW_INDENT_DETAIL AS
>SELECT
>		A.COMPANY																						COMPANY_CODE
>	,	A.IN_RECID																						HEADER_RECID
>	,	B.INI_RECID																						DETAIL_RECID
>	, 	A.INDENT_TYPE 																					INDENT_TYPE
>	, 	A.INDENT_SERIES 																				INDENT_SERIES
>	, 	A.INDENT_NO 																					INDENT_NUMBER
>	, 	A.ENTRY_NO																						ENTRY_NUMBER
>	,	A.DEPARTMENT_CODE 																				DEPT_CODE
>	,	A.INDENT_PERSON																					INDENT_PERSON
>	, 	A.COMPANY||'/'||A.INDENT_TYPE||'/'||A.INDENT_SERIES||'/'||LTRIM(TO_CHAR(A.INDENT_NO, '00000'))	INDENT_INFO
>	,	A.INDENT_DATE																					INDENT_DATE
>	,	A.DEPT_APPROVAL_BY 																				DEPT_APPROVAL_BY
>	,	A.STORE_APPROVAL_BY 																			STORE_APPROVAL_BY
>	,	A.FINAL_APPROVAL_BY 																			FINAL_APPROVAL_BY
>	,	B.INDENT_ITEM_CODE                                                                              INDENT_ITEM_CODE
>	, 	B.STOCK_TYPE																					STOCK_TYPE
>	,	B.ITEM_UM																						UNIT
>	,	B.INDENT_ITEM_QTY																				QTY
>	,	C.ITEM_RATE																						UNIT_PRICE_AS_PER_PO
>	,	C.PO_DATE																						PO_DATE
>	,   A.REMARKS																						INDENT_REMARKS
>	,	B.SUGGESTED_VENDOR	 																			SUGGESTED_VENDOR
>	, 	A.STATUS 																						STATUS
>	,	B.LAST_SUPPLIER 																				LAST_SUPPLIER
>	,	B.LAST_PURCHASE_DATE  																			LAST_PURCHASE_DATE
>	,	B.LAST_PURCHASE_PRICE																			LAST_PURCHASE_PRICE
>	, 	A.CREATED_BY																					CREATED_BY
>	,	A.CREATED_ON																					CREATED_ON
>	,	A.LAST_UPD_BY																					LAST_UPD_BY
>	,	A.LAST_UPD_ON																					LAST_UPD_ON
>FROM INDENTS A, INDENT_ITEMS B, PO_ITEMS C
>WHERE A.IN_RECID 			= 	B.PARENT_RECID
>AND B.COMPANY 				= 	C.COMPANY				(+)
>AND B.INDENT_TYPE 			=	C.PO_INDENT_TYPE_REF	(+)
>AND B.INDENT_SERIES 		=   C.PO_INDENT_SERIES_REF  (+)
>AND B.INDENT_NO				=	C.PO_INDENT_NO_REF      (+)
>AND B.INDENT_SEQ_NO 		=	C.PO_INDENT_SEQ_NO      (+)
>AND B.STOCK_TYPE 			=   C.ITEM_STOCK_TYPE       (+)
> 
>
>
>
>

Actions: View

Attachments on bug 6078: 1786 | 2012